What do the Categories in SQL Server Agent Jobs mean?

sql-server sql-server-2008 sql-server-2005 sql-job
Pankaj picture Pankaj · Aug 16, 2012 · Viewed 14.3k times · Source

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

enter image description here

I am new to SQL Server can you explain the meanings of categories as mentioned above? or any link will be hightly appreciated.

Answer

Tim Harkin picture Tim Harkin · Aug 16, 2012

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/

Related questions

How to avoid the "divide by zero" error in SQL?

I have this error message: Msg 8134, Level 16, State 1, Line 1 Divide by zero error encountered. What is the best way to write SQL code so that I will never see this error message again? I could do either of the following: …

Read More
SQL Server query to find all permissions/access for all users in a database

I would like to write a query on a sql 2008 that will report all the users that have access to a specific database, or objects within the database such as tables, views, and stored procedures, either directly or due to …

Read More
sql query to return differences between two tables

I am trying to compare two tables, SQL Server, to verify some data. I want to return all the rows from both tables where data is either in one or the other. In essence, I want to show all the …

Read More