SELECT
j.name AS JobName,
j.enabled AS JobEnabled,
s.step_id AS StepID,
s.step_name AS StepName,
s.subsystem AS StepType,
s.database_name AS DatabaseName,
s.command AS Command
FROM msdb.dbo.sysjobs j
INNER JOIN msdb.dbo.sysjobsteps s ON j.job_id = s.job_id
--WHERE
database_name like '%database_name%'
ORDER BY j.name, s.step_id;
j.name AS JobName,
j.enabled AS JobEnabled,
s.step_id AS StepID,
s.step_name AS StepName,
s.subsystem AS StepType,
s.database_name AS DatabaseName,
s.command AS Command
FROM msdb.dbo.sysjobs j
ORDER BY j.name, s.step_id;
Comments
Post a Comment