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.
| Author |
Topic |
|
DURGESH
Posting Yak Master
105 Posts |
 Posted - 2008-07-11 : 10:11:00
|
| hi all,i want to schedule a stored procedure at a particular time, bcoz it consume lot of time to generate the report.Can it be possible to do in sql server 2000.can anybody help me to solve this issue.thanks in advanceregardsdurgesh J |
|
|
jhocutt
Constraint Violating Yak Guru
385 Posts |
Posted - 2008-07-11 : 10:40:10
|
| Yes, just create a job, add a step to the job of type Transact SQL. Type exec stored_procedure_name in the command window.Set up the rest of the job parameters as you normally would"God does not play dice" -- Albert Einstein"Not only does God play dice, but he sometimes throws them where they cannot be seen." -- Stephen Hawking |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-12 : 01:30:55
|
| http://msdn.microsoft.com/en-us/library/aa176968(SQL.80).aspx |
|
|
|
|
|
|
how to schedule a stored procedure