- Joined
- Sep 9, 2005
- Messages
- 316
- Reaction score
- 8
Lest start:
1.GO : Start -> All Programs -> Microsoft SQL Server -> Enterprise Manager
2. Console Root > Microsoft SQL Servers > SQL Server Group > IP OR (LOCAL) > Management > SQL Server Agent > Jobs
3.Right Click ,select New Job
4.Name: Money and Owner will be "sa"
5.Go Steps and click New
6.Step Name Money and Database must be set >>>> MuOnline!
7.Copy Paste this:
8.ANd click Parse, OK ,Then go Schedules , click New Shedule
9.Name:Money and click Change
10.Set: Daily, and modify Daily Frequency with Occurs every 1 minute
11.Ok!
Sql Server agent must be started!
1.GO : Start -> All Programs -> Microsoft SQL Server -> Enterprise Manager
2. Console Root > Microsoft SQL Servers > SQL Server Group > IP OR (LOCAL) > Management > SQL Server Agent > Jobs
3.Right Click ,select New Job
4.Name: Money and Owner will be "sa"
5.Go Steps and click New
6.Step Name Money and Database must be set >>>> MuOnline!
7.Copy Paste this:
Code:
UPDATE Character
Set Money=('2000000000')
WHERE Money<1
8.ANd click Parse, OK ,Then go Schedules , click New Shedule
9.Name:Money and click Change
10.Set: Daily, and modify Daily Frequency with Occurs every 1 minute
11.Ok!
Sql Server agent must be started!