Nice to have in Management Studio ...

Question

We have 100s of jobs that perform various activities from pulling data from our ERP system to processing OLAP cubes on our SQL Server 2008 database engine. It would be really nice to be able to see a tree view of our jobs grouped by category and sub-category. The only way to do this currently is to define a job category, attach your job to the job category and filter the jobs under a job category using the "Job Activity Monitor". I hope Microsoft adds this feature in subsequent release(s) of SQL Server.

---

Jagannathan Santhanam

Answer 1

You'll have better results if you submit this suggestion to Microsoft Connect for SQL Server: http://connect.microsoft.com/SQL

I think it's a good idea,

John

Answer 2

Oops! Thanks for the reminder, I am so used to posing questions in this forum that I forgot the protocol :)

Here is the link request to MS: https://connect.microsoft.com/SQLServer/feedback/details/682985/sql-server-2008-job-categories

---

Jagannathan Santhanam

Answer 3

Same issue if you have thousands of tables.  Schema (currently single level) should really be multi-level to support several applications in the same database.

---

Kalman Toth, SQL Server & Business Intelligence Training; sqlusa.com