Display Job Information – SQL Server

by Ray Fox
21/11/201410/07/2015

use [msdb]
select * from sysjobs

select * from sysjobactivity

select * from sysjobs_view

select * from sysjobhistory order by job_id, step_id