Cum opresti gm-ul sa faca levele

Trimis: 21/08/2008 13:31

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 clipe

11: OK la tot si fiti sigur ca SQL Server Agent functioneaza.