Script to list Agent Jobs with Created Date and Time

Script to list Agent Jobs with Created Date and Time


Select a.name, cast(b.date_created as datetime) from  msdb.dbo.sysjobs a
INNER JOIN msdb.dbo.sysJobschedules c ON a.job_id = c.job_id
INNER JOIN msdb.dbo.SysSchedules b on b.Schedule_id=c.Schedule_id
order by cast(b.date_created as datetime) desc