1.Open Your Sql Enterprise Manager and select Management from the left tree menu , Then
select Sql Server Agent
2.Right Click on Jobs and Press New Job and select these propeties
General Tab;
Steps > New;
Replace 2 and 3 with the pklevels you wish
Schedules > New Schedule > Recurring >Change;
For the Date Select Yesterdays Date
Now Press Ok Twice , Right Click On the Sql Server Agent Tabe And Select Start
Once this is Done Right Click on your Pkclear Job and select Start Job.
Finished
is there any way to charge zen for each pk? I can't figure out how to do it... I did once, but it got too buggy! lolz, ppl complained a lot! ^^
add this :
UPDATE character
SET PkLevel= ('0'),Money=Money-('20000000')
WHERE PkLevel>3 and Money>('20000000')
Nice Jobs!!!!!....now i have some problems with the autoreset, it give an error 207: 'Reset ' undefined!
i beliuve i need create a column with the name 'reset', but i dont know how to do exactly, so can some1 explain me that with details????...thx in advance!!!!!!!!!!
coz i was lookind around but with the search dont working is really difficulty!!!!
sry 4 my bad english!!! :P
Here it goes :D
Code:alter table character add reset int null default 0
Last edited by brucesinner; 21-01-05 at 01:32 PM. Reason: added a default = 0
- Open your Enterprises managerOriginally Posted by elche27
- Open your muonline database
- Click on tables
- Right click on the "Character" table
- Click on "Design Table"
- Scroll down to the last column (yes, scroll DOWN to the collumn, pay attention! You will understand as you see it ^^ trust me!)
- Add a "Reset" column after the last one
- In "Data type", make it "smallint"
- uncheck allow nulls (if you don't do it you will have some probs later on!)
- In the Default Value (in the box below) make it 0 or 1... it depends on which reset script you are gonna use, okay?
its done! =]
Sorry for bothering this OOOOLD topic but how to make PK clear command cost less? Can some1 answer me with detailed answer please? I'm a newbie xD
Reply With Quote