automatically Run an Sql statement

[achrafus]

hello everybody, I have an sql statement that I want to automatially run at the beguining of each month from server side. I'm using sql server 2000 and didn't find anything about dbmsjobs in sql! Can anybody help me with that please -- modified at 15:23 Tuesday 27th September, 2005

[Colin Angus Mackay]

You can set up a job that the SQL Server Agent will perform for you on the schedule that you want. Go in to Enterprise Manager, Open the server that you want the job to run on, select the Management folder and then SQL Server Agent and finally Jobs. You can right-click on Jobs and select New Job... and you'll get a dialog that will allow you to define the job. Does this help?

---

My: Blog | Photos "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious

[Bigfootguy]

- Create a DTS Package that will run that SQL statement ( ->Data Transformation Services -> Local Packages ) - Schedule it to run at designated time / interval ( ->Management ->SQL Server Agent ->Jobs ) Best Bigfootguy

[achrafus]

thank you very much

[User 2192404]

what do u think abt triggers.HUH!u can write triggers that will execute it on 1st of every month. get back to me

[Anonymous]

Triggers cannot be scheduled. Triggers get fired only when you delete, update or insert data on a table with triggers.