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 |
|
Arun.G
Yak Posting Veteran
81 Posts |
 Posted - 2010-07-27 : 06:34:27
|
| i have one stored procedurethat stored procedure i want to execute daily at morning at 10 am automatically.how to schedult a job using the stored procedure in sqlserver 2008 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-07-27 : 09:37:36
|
Don't you know how to create a new job?Or what is your problem?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
Arun.G
Yak Posting Veteran
81 Posts |
Posted - 2010-07-28 : 03:12:51
|
| i know to create a job, but im not able to link the particular storedprocedure for mangae job to run daily automaticallycosider i have created one sp called sp_test, tell me, the steps how should i execute the sp daily at mrng 10 am automatically |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-07-28 : 03:18:47
|
| http://msdn.microsoft.com/en-us/library/ms191439.aspxLimitations live only in our minds. But if we use our imaginations, our possibilities become limitless. PBUH |
|
|
|
parody
Posting Yak Master
111 Posts |
Posted - 2010-07-28 : 07:44:11
|
| or are you saying you want the stored procedure to change the job schedule?If so look at msdb.dbo.sp_update_schedule |
|
|
|
Arun.G
Yak Posting Veteran
81 Posts |
Posted - 2010-07-29 : 00:02:23
|
| thanks to all guys, i succesfully created a job and schduled it, and it works fine |
|
|
|
|
|
|
schedule jobs