1: Deschide SQL Server Enterprise Manager
2: Deschide cele 3 sa arate cam asa:
Console Root > Microsoft SQL Servers > SQL Server Group > IP OR (LOCAL) > Management > SQL Server Agent > Jobs
3: Click dreapta si click New Job
4: Denumiti-o gm_reset si setati Owner ca a fi sa
5: Du-te la Steps tab si click New
6: Numeste pasul gm_reset schimba Database ca a fi muonline
7: Copy si paste urmatoarele in Command box:
Code:
UPDATE Character
SET clevel=('349'), experience=('0'), resets=('0')
WHERE ctlcode=('8')
8: Click OK then go to the Schedules tab and click New Schedule
9: Denumiti-o gm_reset si click Change jos de tot in dreapta
10: Schimbati la occur la Daily, Daily Frequency to Occurs every 1 minute
11: OK la tot si fiti sigur ca SQL Server Agent functioneaza