Wednesday, 26 March 2025

To find list of the job names and step associated with a particular table

Use MSDB

go

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]

No comments:

Post a Comment

To Shrink Tempdb