Auto PK clear folosind SQL

Este simplu...
Doar foloseste si respecta pasii din ghid.

1. Mergi in: Start -> All Programs -> Microsoft SQL Server -> Enterprise Manager.

2. Open tree : Microsoft SQL Servers -> SQL Server Group -> (local) (Windows NT) -> Management.

Right Click in SQL Server Agent -> Start.
Open tree: SQL Server Agent -> Jobs.

3. Right click in blank space din dreapta si alege New Job...

Name: AutoPkClear
Owner: Select sa

4 Select Steps.
Click New...
Step Name: AutoPkClear.
Database: MuOnline
Command:
Pune in Query urmatoarele :

Citat
UPDATE Character
SET PkLevel = ('0') , PkTime = ('0') , PkCount = ('0')
WHERE PkLevel>2
Click: Parse, Apply, Ok.
--
5 Select Schedules
Click New Schedule
Name: AutoPkClear.
Click Change...
Occurs: Select Daily.
Daily Frequency: Select Occurs every.
Where: Hours select Minutes.
Click: Ok 2 times.
Click: Apply then Ok.
--
6 AutoPkClear la 1 minut cand cineva este Phono , poti sa folosesti acest script in orice mu server version