New Job Schedule / Job Schedule Properties
Use this page to view and change the properties of the schedule.
Options
- Name
Type a new name for the schedule.
- Jobs in schedule
View the jobs that use the schedule.
- Schedule type
Select the type of schedule.
- Enabled
Check to enable or disable the schedule.
Recurring Schedule Types Options
- Occurs
Select the interval at which the schedule recurs.
- Recurs every
Select the number of days or weeks between recurrences of the schedule. This option is not available for monthly recurring schedules.
- Monday
Set the job to occur on a Monday. Only available for weekly recurring schedules.
- Tuesday
Set the job to occur on a Tuesday. Only available for weekly recurring schedules.
- Wednesday
Set the job to occur on a Wednesday. Only available for weekly recurring schedules.
- Thursday
Set the job to occur on a Thursday. Only available for weekly recurring schedules.
- Friday
Set the job to occur on a Friday. Only available for weekly recurring schedules.
- Saturday
Set the job to occur on a Saturday. Only available for weekly recurring schedules.
- Sunday
Set the job to occur on a Sunday. Only available for weekly recurring schedules.
- Day
Select the day of the month the schedule occurs. Only available for monthly recurring schedules.
- of every
Select the number of months between occurrences of the schedule. Only available for monthly recurring schedules.
- The
Specify a schedule for a specific day of the week on a specific week within the month. Only available for monthly recurring schedules.
- Occurs once at
Set the time for a job to occur daily.
- Occurs every
Set the number of hours or minutes between occurrences.
- Start date
Set the date when this schedule will become effective.
- End date
Set the date when the schedule will no longer be effective.
- No end date
Specify that the schedule will remain effective indefinitely.
One Time Schedule Types Options
- Date
Select the date for the job to run.
- Time
Select the time for the job to run.
See Also
Other Resources
Creating Schedules
How to: Schedule a Job (SQL Server Management Studio)