SqlShare.com Logo
 
Skip Navigation Links
Home
Video List
Events
Classes
About Us
Login / Register
Subscribe RSS Feed 

Confio Ignite 8

Working with SQL Agent Job Categories

Are you putting all your jobs into one basket? It doesn't take much work to set up a few categories that make sense for your environment and build the habit of assigning all new jobs to a category. It makes it a lot easier for (and the next person) to find a job when the name of the job doesn't immediately come to mind. Haven't been using categories? Add it to your schedule to start fixing up all your existing jobs!

Duration:
2 mins 4 secs
Skill Level:
100
Rating:
4.25 out of 5
Publish Date:
November 13, 2009
Working with SQL Agent Job Categories You must be logged in to view this video.  
Bookmark and Share
 
1=Poor, 3=Good, 5=Excellent

About the Author

Image of Andy Warren
Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

References

There are no downloads or recommended reading links for this video

Comments
Daniel Thompson on 11/19/2009
Didn't say how to use the categories to your advantage.

Will Casey on 11/19/2009
Good post and good idea, but is there a way to place those categories in a folder like structure? IMO it would make sense if the categories were more visually separate in SSMS instead of just having a long list of all jobs.

valluru raghu on 11/19/2009
good

Geoffrey Doebler on 11/19/2009
It'd be great if under the Jobs folder, there could be a folder for each category.

Emery on 11/19/2009
Excellent tip. I wasn't aware of it...

Don Weigend on 11/19/2009
Using categories is a great idea. In our shop we have what we call standard server jobs. Placing these into a category seems to make sense if for nothing else, to be able to view all jobs on a server that are in that category. Thank you for the tip!

D151BB6B9F on 11/19/2009
You didn't show the value of this after you put a job into a category- i.e. how is that useful?

lucas on 11/19/2009
learned: how to add your own categories (simple but the one time I looked for it I didn't look good enough...)

Ratheesh.K.Nair on 11/19/2009
Informational...No idea about this for the last 3 years

Thomas Maloney on 11/22/2009
I was not aware of this functionality

Carla Wilson on 11/24/2009
A very useful tip. Thanks!

Christian Bahnsen on 11/25/2009
Great tip. I'm just getting started with jobs and I can see how this will help organize them

ML Stephens on 11/27/2009
common sense

Sandip on 12/19/2009
great

Steve Culshaw on 12/23/2009
Another excellent tip

A Alagu Ganesh on 2/10/2010
Good



Must Be Logged In
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions