Page History

After you define your steps, you can set several schedules for your job. SQL Enterprise Job Manager displays a Schedule list on this window. On this list, you can see the schedule ID, name, if the schedule is enabled, and the description specified for in this schedule.  

At the top of this section you can find the following options:

• New - lets you create a new schedule to be added to your job.
• Pick - allows you to select a schedule from those available in your instance. Keep in mind that jobs and schedules must have the same owner; therefore, you can only select schedules that you own. Click this option to access a new window of available schedules, select the one you want to use for your job. You can also edit the selected schedule and change its properties.  
• Edit - lets you make changes to a selected schedule.
• Remove - allows you to delete a selected schedule

...

• Start automatically when SQL Server Agent Starts - if you choose this option, then the job starts automatically when the SQL Server Agent starts. You do not need to specify anything else in your schedule if you choose this option.  
• Start whenever the CPUs become idle - select this option when you want to start the job whenever the CPUs become idle. You do not need to specify anything else in your schedule if you choose this option. 
• Recurring - select this option if you want to perform your job on a recurring schedule. If you choose this option, you need to specify the frequency, daily frequency, and duration. You can find more details about these sections in on the topics below. 
• One time - if you only want to execute your job one time, choose this option. The section One-time occurrence becomes enabled for this option and the rest of the sections become disabled. 

...

This option is only available when you select Recurring in your schedule type. 

On this section, you can specify if you want the frequency of your schedule to be: Daily, Weekly, or Monthly. SQL Enterprise Job Manager displays different options depending on the frequency option you choose. 

• If you choose  Daily, specify in the field Recurs every how often in days the job runs. For example, you can set the job to run every 2 days. 
• If you choose  Weekly, define the following fields:
  • In the field Recurs every specify how often in weeks the job runs. For example, you can determine to run a job every 2 weeks.  
  • The weekly frequency. Select those days of the week when the job runs (Monday, Tuesday, etc.)
• If you choose Monthly, you can choose between these two options:
  • The exact day of the month and how often in months the job runs. For example, if you want to set a job to run the 10th day of a month and every 2 months, you have to specify: Day 10 of every 2 months.
  • Alternatively, when you do not know specific dates, you can select the first, second, third, fourth, or last day of a specific day in the month (Monday, Tuesday, weekday, weekend day, etc.) and how often in months the job runs. For example, if you want to run the job the second weekday of every 3 months, you have to specify The second weekday of every 3 months.

...

• Occurs once at -lets you determine a time in the day when you want your job to run.
• Occurs every - lets you schedule your job several times during the day. You can determine if you want the job to run multiple times every certain hours, minutes, or seconds. Additionally, SQL Enterprise Job Manager lets you determine the Starting at and the Ending at time of your job daily frequency. 

For example, you can set the following schedules:

...

SQL Enterprise Job Manager monitors and manages your SQL Server agent jobs. Learn more > >

...

...