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

This topic describes how to create a schedule for SQL Server Agent jobs. Before running the procedure in this topic, review Creating and Attaching Schedules to Jobs.

To schedule a job

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

  2. Expand SQL Server Agent, right-click Jobs, and select Manage Schedules.

  3. In the Manage Schedules dialog box, click New.

  4. In the Name box, type a name for the new schedule.

  5. If you do not want the schedule to take effect immediately after it has been created, clear the Enabled check box.

  6. For Schedule Type, select one of the following:

    • To start the job when the SQL Server Agent service is started, click Start automatically when SQL Server Agent starts.

    • To start the job when the CPUs reach an idle condition, click Start whenever the CPUs become idle.

    • If you want a schedule to run repeatedly, click Recurring. To set the recurring schedule, complete the Frequency, Daily Frequency, and Duration groups on the dialog.

    • If you want the schedule to run only one time, click One time. To set the One time schedule, complete the One-time occurrence group on the dialog box.