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 |
|
arorarahul.0688
Posting Yak Master
125 Posts |
 Posted - 2009-12-24 : 04:26:20
|
| Hi,Merry Christmas to all.....Hope you can help me to find the solution to schedule execution of a stored procedure in Sql server 2k5 without using ETL package.thanks,Rahul :)Rahul Arora NCCE, Panipat ######################IMPOSSIBLE = I+M+POSSIBLE |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-12-24 : 04:36:34
|
| u can schedule a job |
 |
|
|
arorarahul.0688
Posting Yak Master
125 Posts |
Posted - 2009-12-24 : 05:03:02
|
Thanks, I Have created the job and scheduled that too...Is there any thing else off which i have to take care?quote:
Originally posted by bklr
u can schedule a job
Rahul Arora NCCE, Panipat ######################IMPOSSIBLE = I+M+POSSIBLE |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2009-12-24 : 05:15:57
|
| just make sure the SQL Agent is running and has access to complete all steps within the package...particularly if it is tasked with manipulating external files. |
|
|
|
arorarahul.0688
Posting Yak Master
125 Posts |
Posted - 2009-12-24 : 05:45:32
|
Thanks Andrew...this really helped :)quote:
Originally posted by AndrewMurphy
just make sure the SQL Agent is running and has access to complete all steps within the package...particularly if it is tasked with manipulating external files.
Rahul Arora NCCE, Panipat ######################IMPOSSIBLE = I+M+POSSIBLE |
|
|
|
|
|
|
Schedule the procedure Execution