view log to table job latest job

Question

Dear SQL friends,

I would like to query the history of a job. I know you can see via log to table this info, but this is only the latest job.
Is there a way to view the same info of jobs run before the latest one?

kind regards,
Marco

Answer 1

Not sure what you really want. Here is an example script to list the job execution history for the job "syspolicy_purge_history":

USE [msdb];
GO

SELECT j.*, jh.*
  FROM [dbo].[sysjobs] AS j
INNER JOIN [dbo].[sysjobhistory] AS jh 
    ON j.job_id = jh.job_id
 WHERE j.name = 'syspolicy_purge_history'   -- Job Name
   AND jh.step_id = 0                       -- Job level
ORDER BY jh.run_date DESC;
GO

Answer 2

Hi @Anonymous ,

Please refer to this docs: View the Job History
Simply you can use the first two methods: SSMS or T-SQL.
SSMS:

T-SQL (for example):

USE msdb ;    
GO    
  
EXEC dbo.sp_help_jobhistory     
    @job_name = N'syspolicy_purge_history' ;    
GO    

Best regards,
Seeya

---

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.