How Can I Scheduling a JOB ?

[snr]

Hi !
Does anyone knows how can I schedule a job for a perticular timing in sql server ?

 

[snr]

I want to execute a piece of code every day at 9 pm ...
Can I write a trigger and specify the clock timing ?
Or can I write a stored procedure which will execute exactly at 9 ?

Please tell me what you ment by JOB ?

 

[tlbroadbent]

Do you have Enterprise Manager (EM)? If you have it do the following.

1) Open the server in EM
2) Open Management
3) Open SQL Server Agent
4) Right-click Jobs
5) Select New Job - New Job Properties will open
6) Fill in the blanks. You can have the Job run a stored procedure, OS command, ActiveX script, etc.
7) Read more about Job scheduling in SQL Books Online. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[snr]

Thanks .....
Now I think I will be able to do !
Thanks again