在作业中执行存储过程 [英] Execute stored procedure in a job

问题描述

大家早上好





如何在作业中执行存储过程以及如何在作业中将参数传递给sp



请告诉我

感谢你.....

Good Morning to all


How to execute Stored procedure in a job and how to pass parameters to sp in job

please tell me
thanking you.....

推荐答案

One选项是创建一个表来存储参数值并更新存储过程，以便在作业执行时读取表中的值。

One option would be to create a table to store the parameter values in and update your stored procedure to read the values out of the table when it is executed by the job.

你可以检查这个< br $> b $ b

如何执行存储过程在sql-agent-job中的作业 [ ^ ]



希望它会有所帮助..

You can check this

how-to-execute-a-stored-procedure-in-a-sql-agent-job[^]

Hope it will help..

这篇关于在作业中执行存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！