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:
...
- 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.
...
- 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:
...