Write a query to get jobs working in SQL Server Database?
Below are the two query which helps you to get all the jobs working in SQL Server:-
(1)SELECT jss.jobname, jss.step_name, p.name FROM sys.procedures p
CROSS apply
(
SELECT j.name AS jobname, js.step_name FROM msdb.dbo.sysjobsteps js
INNER JOIN msdb.dbo.sysjobs j ON js.job_id=j.job_id
WHERE js.command LIKE '%'+p.name+'%'
) jss
(2)SELECT s.step_id, j.[name], s.database_name, s.command
FROM msdb.dbo.sysjobsteps AS s
INNER JOIN msdb.dbo.sysjobs AS j ON s.job_id = j.job_id
WHERE s.command LIKE '%ProcAdsDetailQsn%'
SQL Server Database,get jobs working in SQL,SQL Query,SQL Query jobs | |