如何编程任务调度程序以执行存储过程SQL Server 2008 [英] How to program the task scheduler to execute a stored procedure SQL server 2008

问题描述

请提供从 Windows中的任务计划程序执行带参数的存储过程所需的必要步骤



或网络参考。







EXEC [dbo]。[sp_simple] @ZIDNO， @ZLOANUMBER





谢谢



我尝试了什么：



我试图从任务计划程序运行它，但遗憾的是无济于事。





试过网络，但得不到正确答案



谢谢

Kindly provide the necessary steps required to Execute a stored procedure with parameters from the Task Scheduler in windows

or a web reference.



EXEC [dbo].[sp_simple] @ZIDNO,@ZLOANUMBER


Thanks

What I have tried:

I have tried to run it from the Task Scheduler, unfortunately to no avail.


Tried the web, but not getting the right answer

Thanks

推荐答案

使用批处理文件从命令行运行它： https://ask.sqlservercentral.com/questions/2931/how-to-call-a-stored-procedure-from-command-line.html [ ^ ]

然后正常运行任务计划程序中的批处理文件。

Use a batch file to run it from the command line: https://ask.sqlservercentral.com/questions/2931/how-to-call-a-stored-procedure-from-command-line.html[^]
Then just run the batch file from task scheduler as normal.

这篇关于如何编程任务调度程序以执行存储过程SQL Server 2008的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！