sql | SQL Server‎ > ‎sqlsrv | T-SQL‎ > ‎

tsql | Job data

SELECT JOB.NAME AS JOB_NAME,
 STEP.STEP_ID AS STEP_NUMBER,
 STEP.STEP_NAME AS STEP_NAME,
 STEP.COMMAND AS STEP_QUERY,
 DATABASE_NAME, *
 FROM Msdb.dbo.SysJobs JOB
 INNER JOIN Msdb.dbo.SysJobSteps STEP ON STEP.Job_Id = JOB.Job_Id
 WHERE JOB.job_id = 0x4EB091BA9256F045842A205443A5DA1C
Comments