查看sqlserver代理作业日志

在 msdb 下

  select [dbo].[sysjobs].name,* from [msdb].[dbo].[sysjobhistory] inner join [dbo].[sysjobs] on [dbo].[sysjobhistory].job_id = [dbo].[sysjobs].job_id 
  where [dbo].[sysjobs].name = '作业名'