Export (0) Print
Expand All
Expand Minimize

Job Schedule Properties

SQL Server 2000

Use this dialog box to view or specify the following options.



Specify the name of the schedule. The name is limited to 128 characters. Each schedule name in a job must be unique.


Enable the new job schedule.

Start automatically when SQL Server Agent starts

Automatically start the job when SQL Server Agent starts.

Start whenever the CPU(s) become idle

Start the job whenever the CPU(s) become idle. CPU idle time is specified on the Advanced tab of the SQL Server Agent Properties dialog box.

One time

Start the job once at the specified date and time.

On date
Specify the date you want the job to start.
At time
Specify the time you want the job to start.


Start the job according to the recurring schedule displayed.


Display the Edit Recurring Job Schedule dialog box, where you can change the current recurring job schedule.

See Also

Scheduling Jobs

© 2014 Microsoft