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 : 05:28:56
|
| Hi all,I have a query, Is there any way by which we can use Batch file to schedule my Sql Server Stored Procedure Code.Please let me know if nay one have idea about this.Thanks,RahulRahul Arora NCCE, Panipat ######################IMPOSSIBLE = I+M+POSSIBLE |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-12-24 : 05:57:03
|
| why not just set up a job using sql server agent instead?Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-12-24 : 09:32:19
|
I agree with Charlie...but to answer the question, you file will look like this:Sqlcmd -Sservername -ddatabasename -q "exec yourStoredProcedure" -E see here: http://msdn.microsoft.com/en-us/library/ms162773.aspx |
|
|
|
|
|
|
Batch file to schedule the Stored Procedure code