SQL Tips #19 - Listing All SQL Jobs on the Server

A quick way to list every SQL Agent job on the server, along with its owner.

The Query

select * from msdb..sysjobs sj left join master.sys.syslogins sl on sj.owner_sid = sl.sid

Disclaimer

These queries are provided as a guide, and are by no means perfect. I didn't write all of these - many are collated from MSDN documentation and community sources over the years.

Tags