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 |
sql | SQL Server > sqlsrv | T-SQL >