I know how to assign or create "categories" for jobs. But is there a way to actually view jobs by category by default. I do not want to see all the jobs just listed within SQL Server Agent. I'd like to be able to have a view where I expand "SQL Server Agent" and I first see all the categories and I can expand each category to see the SQL job. Is this possible?

I already know I can right click the jobs folders and do "Manage Categories" and view jobs by category there, but that is not what I am looking for. I am looking for a default view to show jobs by category.

  • What you are asking is not possible. You should create an SP with categories as input parameter and then use it to view the data from msdb. – Kin Shah Sep 25 at 14:17
  • @KinShah - Thats a shame considering you cannot create folders to store jobs in. The purpose of categories is pointless to say the least. – JonH Sep 25 at 14:18
  • Open a connect item and lets see if MS will address this or not :-) Good luck ! – Kin Shah Sep 25 at 14:18
  • 1
    @KinShah - No thanks - I used to do that with SSRS and I got nowhere. It is what it is but it seems this is something that would make sense to organize and group jobs. – JonH Sep 25 at 14:40
  • If it's too much effort to create a feature request in Connect (now in Azure), you can vote this one up. It's close to what you want. feedback.azure.com/forums/908035-sql-server/suggestions/… – Doug Deden Sep 25 at 15:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.