How to: Create a Job (SQL Server Management Studio)

This topic describes how to create a Microsoft SQL Server Agent job for automatic administration.

To create a job

  1. In the Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance.

  2. Expand SQL Server Agent.

  3. Right-click Jobs, and then click New Job.

  4. On the General page, in the Name box, type a name for the job.

  5. Clear the Enabled check box if you do not want the job to be run immediately following its creation. For example, if you want to test a job before it is scheduled to run, disable the job.

  6. In the Description box, enter a description of what the job does. The maximum number of characters is 512.

To add job steps, schedules, alerts, and notifications that can be sent to operators, see the links to how-to topics that follow.

See Also

Tasks

How to: Create an ActiveX Script Job Step (SQL Server Management Studio)
How to: Create a CmdExec Job Step (SQL Server Management Studio)
How to: Create a Transact-SQL Job Step (SQL Server Management Studio)
How to: Create an ActiveX Script Job Step (SQL Server Management Studio)
How to: Create an Analysis Services Job Step (SQL Server Management Studio)
How to: Schedule a Job (SQL Server Management Studio)
How to: Create an Alert Using an Error Number (SQL Server Management Studio)
How to: Create an Alert Using Severity Level (SQL Server Management Studio)
How to: Notify an Operator of Job Status (SQL Server Management Studio)

Help and Information

Getting SQL Server 2005 Assistance