Reputation: 1808
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
Reputation: 280252
This will return n
rows, and their names:
SELECT name FROM msdb.dbo.sysjobs;
Upvotes: 2