有没有办法搜索和查找哪个作业持有特定的表刷新。存在多个具有多个steps.What的sql代理作业,是用sql查询来搜索所有作业并定位作业名称和步骤吗?
这是为了标识与表load相关的步骤
发布于 2018-05-31 18:50:01
看看这个:
use msdb
SELECT
[sJOB].[job_id] AS [JobID]
, [sJOB].[name] AS [JobName]
,step.step_name
,step.command
FROM
[msdb].[dbo].[sysjobs] AS [sJOB]
LEFT JOIN [msdb].dbo.sysjobsteps step ON sJOB.job_id = step.job_id
WHERE step.command LIKE '%MYTABLENAME%'
ORDER BY [JobName]
https://stackoverflow.com/questions/50622312
复制相似问题