如何使用SQL语句 将作业调度生成脚本?

use MSDB
select command from sysjobsteps where job_id=(select job_id from sysjobs where name='作业名称') order by step_id

有关AGENT SERVICE的数据大部分记录在MSDB库中
作业表为sysjobs
作业步骤在sysjobsteps表中

详细资料请查看联机文档“系统表”部分

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus