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 Namebox, 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.