Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Executing a procedure @ a specific time of the day

Author  Topic 

kam
Starting Member

17 Posts

Posted - 2006-03-25 : 09:46:27
Can someone direct me to how I achieve this.

Many thanx

Kam.

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-03-25 : 10:02:21
Create a job which will excute the procedure at the given time..

If Debugging is the process of removing Bugs then i Guess programming should be process of Adding them.
Go to Top of Page

kam
Starting Member

17 Posts

Posted - 2006-03-25 : 10:19:35
How do I create a job?
Go to Top of Page

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-03-25 : 10:35:39
Following are the steps which are require to create a job

A) Go to Enterprize manager
B) In the Managment->SQL Server Agent there is a option of job
C) Right click and click on new job..

Then follow the instruction its very simple.. and also you can go through book online for the details..

Hope these helps you..

If Debugging is the process of removing Bugs then i Guess programming should be process of Adding them.
Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-03-25 : 15:50:17
You might also want to read up on waitfor: in books online
Go to Top of Page
   

- Advertisement -