Grasshopper
Grasshopper

Reputation: 1808

How to find the number of Jobs in SQL Server Agent Jobs?

Do we have a way to find the number of jobs currently in SQL Server Agent and there names. I can count manually but i am looking for a script to give me the number and names.

Thank you

Upvotes: 0

Views: 5920

Answers (1)

Aaron Bertrand
Aaron Bertrand

Reputation: 280252

This will return n rows, and their names:

SELECT name FROM msdb.dbo.sysjobs;

Upvotes: 2

Related Questions