I've got an extensive selection of these to add to a spreadsheet and don't want to go through by hand. What it the T-SQL command(s) to generate a list of SQL Server Agent Jobs?
On each server, you can query the sysjobs table in the msdb. For instance:
SELECT job_id, [name] FROM msdb.dbo.sysjobs;
-- List of all the jobs currently running on server 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
Here is my contribution - also gets the category name and filters out the report server jobs.
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
My boss actually sorted out what I was after - this gave me the list I was after.
USE msdb SELECT name FROM sysjobs
protected by splattne May 31 '11 at 13:10
Thank you for your interest in this question.
Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?