Query to list the job names and step associated with a particular table

Question

Is there any way to search and find ,what job holds a particular table refresh . There are multiple sql agent jobs with multiple steps.What is the sql query to search all jobs and locate the job name and steps?

This is to identify the steps associated with a table load

Iain

serverfault.com/questions/14524/… – Oleograph

Possible duplicate of How to find all SQL Agent Jobs that call a given stored-proc – Carthy

Answer 1

Take a look at this:

Querying SQL Agent Jobs

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]

Teresaterese