Reputation: 10115
This is the first time I am trying for the SQL Job Agent...I was trying to create the sample job and I got struck in between when it came to select the Category as highlighted in the below screen shot
I am new to SQL Server can you explain the meanings of categories as mentioned above? or any link will be hightly appreciated.
Upvotes: 13
Views: 18579
Reputation: 9602
The Tim Ford's article on the categories at mssqltips.com referenced in the accepted answer describes how to add categories, but not what the existing categories are.
Upvotes: 6
Reputation: 180
Categories are used for organizing your jobs. If you right click on the jobs folder and select "Manage Categories" you can see all of the categories available, filter by category, etc.
There is a good breakdown here:
http://www.mssqltips.com/sqlservertip/1484/custom-job-categories-to-organize-your-sql-agent-jobs/
Upvotes: 9
Reputation: 6330
Job categories help you organize your jobs for easy filtering and grouping.
if you are having multiple job for same type of task or operations than you can categoris your job as per the job nature
read more from http://msdn.microsoft.com/en-us/library/ms191128.aspx
Upvotes: 2
Reputation: 239824
They don't affect the job at all - they're merely a means of organizing jobs - quite helpful if you have a lot of jobs on a single server.
You can add your own categories using sp_add_category
in msdb
.
Many of the built in categories will be used automatically when you're setting up other parts of SQL Server, and it adds jobs. E.g. if you set up merge replication, you'll find that some jobs are added under the REPL-Merge
category.
Upvotes: 6