How to schedule a job (Enterprise Manager)

How to Install SQL Server 2000

How To

How to schedule a job (Enterprise Manager)

To schedule a job

  1. In the details pane, right-click the job, click Properties, click the Schedules tab, and then click New Schedule.

  2. In the Name box, enter a name for the new schedule.

  3. Clear the Enabled check box if you do not want the schedule to take effect immediately following its creation.

  4. Under Schedule type, do one of the following:
    • Click Start automatically when SQL Server Agent starts to start the job when the SQL Server Agent service is started.

    • Click Start whenever the CPU(s) become idle to start the job when the CPU(s) reach an idle condition.

    • Click One time if you want a schedule to run once. To set the one time schedule, enter values in the On date and At time boxes.

    • Click Recurring if you want a schedule to run repeatedly. To set the recurring schedule, click Change, and then complete the Edit Recurring Job Schedule dialog box.