Tutorial - Auto reset

Acoustic · Trimis: 03/02/2008 21:26 Titlul subiectului: Tutorial - Auto reset

Haideti sa invatam sa facem Auto_Reset Smile

1.Intrati in Enterprise Menager : Start >> All Programs >> Microsoft SQL Server >> Enterprise Menager

2.Microsoft SQL Server >> SQL Server Group >> (local0 (Windous NT) >> Management >> SQL Server Agent >> Jobs >> New job...

3.General >>
Name : Auto_Reset
Category : [Uncategorized (Local)]
Owner : sa
Description : Facem auto reset

4.Steps >> New...

5.General >>
Step name : Step 1
Type : Transact-SQL Script (TSQL)
Command >>
UPDATE Character
SET clevel= ('/1/') , experience= ('/0/')
WHERE clevel>349

6.Schedules >> New Schedule...

7.Change...

8.
Occours : Daily
Daily : Every 1 day(s)
Daily frequency : 1 Minute(s)

9.
Name : Schedule 1

10.Aplly >> OK

11.SQL Server Agent >> Start

Cam Atat