Einam i Start > Programs > Sql Server > Enterprise Manager
Atidarom Microsoft SQL Servers > SQL Server Group > (local) (Windows NT) > Management > desinys peles klavisas ant SQL Server Agent > Start
Atidarom toje kategorijoje Jobs.
Desinys peles kavisas > New Job
Name bus RepairStats
Owner pakeisti i 'sa'
Eikite i Steps tab, sukurti New Job
Pavadinimas: step1
database : muonline
command :
UPDATE Character
SET Strength = '32766'
WHERE Strength < '1'
UPDATE Character
SET Dexterity = '32766'
WHERE Dexterity < '1'
UPDATE Character
SET Vitality = '32766'
WHERE Vitality < '1'
UPDATE Character
SET Energy = '32766'
WHERE Energy < '1'
sukurti parse, tada paspauskite apply ir tada ok
Dabar eikite i Schedules, apauskite sukurti New Schedule
Name : RepairStats
Reccurting > Change
Occurs : Daily, every 1 days
Daily frequerency : occurs every : 1 minute
duration :
start date - parasykite siandienos
sukurkite NO End date, ir spauskite 2 kartus ok.
Spauskite apply tada ok, desinys pales klavisas ant RepairStats job ir spauskite Start job.
Kas minute, kas dien jusu sql tikrinas ar serveryje niekas nera "persiminkes" statu ir rades perminkytus pakeis juos i 32766.
