This post is a guide on how to list all SQL Agent Jobs on a SQL Server Instance, by using a TSQL script that queries system tables for this information.
The sysjobs and sysjobsteps tables we are querying are in the M-S-D-B database. Interesting fact, I am unable to post this database name without seeing a JSON error.
Microsoft documentation as always has us covered for the need to know meanings for columns within each table.
List all SQL Agent jobs in SQL Server
As mentioned above we’re querying the database. The following script will return a list of all the SQL Agent jobs on the SQL Server host –