Enter the name of the job schedule.

Selections for job frequency include:

-One time: The scheduled process runs once, on the date and time specified in the One-time occurrence field.

-Daily: The scheduled process runs on a daily basis. In the Frequency section, specify the number of days to lapse between each run of the job. In the Daily frequency section, specify a time for the process to run or specify that the process run repeatedly during a specific period of time. In the Duration section, specify the date that your process begins. If you want the process to run over a specific period of time, specify an optional End date or keep the default of No end date.

-Weekly: The scheduled process runs on a weekly basis. In the Frequency section specify the number of weeks to lapse before the process runs, in addition to the day of the week for it to run. In the Daily frequency section, set a specific time for the process to run, or specify that the process run repeatedly during a specific period of time. In the Duration section, specify the date that your process begins. If you want the process to run over a specific period of time, specify an optional End date or keep the default of No end date.

-Monthly: The scheduled process runs on a monthly basis. In the Frequency section, specify the number of months to lapse before the process runs, in addition to the day of the month for it to run. In the Daily frequency section, specify a specific time for the process to run or specify that the process run repeatedly during a specific period of time. In the Duration section, specify the date that your process begins. If you want the process to run over a specific period of time, specify an optional End date or keep the default of No end date.

-Start when SQL Server Agent service starts: The scheduled job process runs when the SQL Server Agent service starts. This is useful if you use the SQL Server Agent service for other tasks.

-Start when the computer becomes idle: The job runs when enough resources are available on the server. This is determined by the idle condition defined in the SQL Server Agent properties on the server.

To suspend the scheduled process, unmark this checkbox. To make the process active, mark Enabled. By default, this checkbox is marked.

Appears when you select One time in the Schedule type field. Use the date format mm/dd/yyyy, or click the drop down arrow to select from a calendar.

Appears when you select One time in the Schedule type field. Enter the date of the one-time occurrence.

Enabled when you select Daily, Weekly, or Monthly in the Schedule type field.

Appears when you select Weekly in the Schedule type field. Mark the checkbox beside the day of the week to run the job. You can select one or multiple days.

Appears when you select Monthly in the Schedule type field.

Appears when you select Monthly in the Schedule type field. In the first field select First, Second, Third, Fourth, or Last. In the second field select a day of the week or Day, Weekday, or Weekend day. For example, to run a process the last Friday of every month, select Last in the first field and Friday in the second field.

Enabled when you select Daily, Weekly, or Monthly in the Schedule type field.

Enabled when you select Daily, Weekly, or Monthly in the Schedule type field. To move the number by one, click the up and down arrow in the first field. In the second field, select Minutes or Hour. For example, to run this process in the morning and afternoon every day at work, enter 4 in the first field and select Hours in the second field.

Enabled when you select Occurs every [ ] [ ]. Using the example in the previous row, enter 8:00:00AM in the Start at field and 5:00:00PM in the Ending at field.

Enter the date for the job schedule to begin to process. Use the date format mm/dd/yyyy, or click the arrow to select from a calendar.

Enter the date for the job schedule to end. For example, enter an end-of-year date. Use the date format mm/dd/yyyy, or click the arrow to select from a calendar. This option is disabled when No end date is selected.