SQL Server | SQL Server Agent Jobs currently running on the SQL Server

---

Get a list of SQL Server Agent Jobs

---

To get the list of all SQL Server Agent Jobs running on the current server.

Query: List of all the jobs currently running on the server

SELECT job_id, [name] FROM msdb.dbo.sysjobs;

SELECT job.job_id, notify_level_email, name, enabled, description, step_name, command, server, database_name
FROM msdb.dbo.sysjobs job
INNER JOIN msdb.dbo.sysjobsteps steps ON job.job_id = steps.job_id
WHERE job.enabled = 1 -- remove this if you wish to return all jobs

Also gets the Category Name and filters out the jobs of the Report Server Category.

SELECT  sysjobs.name 'Job Name', syscategories.name 'Category',
CASE [description] WHEN 'No Description available.' THEN '' ELSE [description] END AS 'Description'
FROM msdb.dbo.sysjobs
INNER JOIN msdb.dbo.syscategories ON msdb.dbo.sysjobs.category_id = msdb.dbo.syscategories.category_id
WHERE syscategories.name <> 'Report Server'
ORDER BY sysjobs.name