Manage Partition Wizard (New Job Schedule Page)

Use the New Job Schedule page to view and change the properties of the schedule.

Options

Select the type of schedule you want for the SQL Server Agent job.

  • Name
    Type a new name for the schedule.

  • Jobs in schedule
    View the existing jobs that use the schedule.

  • Schedule type
    Select the type of schedule.

  • Enabled
    Enable or disable the schedule.

Recurring Schedule Types Options

Select the frequency of the scheduled job.

  • 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 schedules.

  • Monday
    Set the job to occur on a Monday. Only available for weekly schedules.

  • Tuesday
    Set the job to occur on a Tuesday. Only available for weekly schedules.

  • Wednesday
    Set the job to occur on a Wednesday. Only available for weekly schedules.

  • Thursday
    Set the job to occur on a Thursday. Only available for weekly schedules.

  • Friday
    Set the job to occur on a Friday. Only available for weekly schedules.

  • Saturday
    Set the job to occur on a Saturday. Only available for weekly schedules.

  • Sunday
    Set the job to occur on a Sunday. Only available for weekly schedules.

  • Day
    Select the day of the month the schedule occurs. Only available for monthly schedules.

  • of every
    Select the number of months between occurrences of the schedule. Only available for monthly schedules.

  • The
    Specify a schedule for a specific day of the week on a specific week within the month. Only available for monthly 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

If you schedule a job to run once, you must select a date and time in the future.

  • Date
    Select the date for the job to run.

  • Time
    Select the time for the job to run.