Historial de ejecución de Jobs en SQL Server

 USE msdb

GO  
SELECT J.[name] 
       ,[step_id]
       ,[step_name]
      ,[message]
      ,[run_status]
      ,[run_date]
      ,[run_time]
      ,[run_duration]
  FROM [msdb].[dbo].[sysjobhistory] JH
  JOIN [msdb].[dbo].[sysjobs] J
  ON JH.job_id = J.job_id
  WHERE J.name like 'JOB_MyApp_%'
  ORDER BY J.name, [run_date] desc, [run_time] asc, [step_id], [step_name]
GO

Jerarquía organizacional