Page History
...
- 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
...
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.
...
| Info |
|---|
After making your settings in the Schedule section of this wizard, you can finish and save the job, or you can go to any of these sections: General, Steps, Alerts, Notifications, Targets. |
SQL Enterprise Job Manager monitors and manages your SQL Server agent jobs. Learn more > >
...
...