Job Schedules Tab

To view the job schedules set for the business process, select the Job schedules tab. In the grid, you can view the job schedules set for the job. For each job schedule, you can view its job name, whether it is enabled, its frequency, its start date and time, its end date and time, and the dates the schedule was added and changed in the database.

From the Job schedules grid, you can manage the job schedules set for the business process.

To automate a process, you can create a job schedule for the process. When you create a job schedule, you define when the job begins to run.

  1. On the status page for the business process, select the Job schedules tab and select Add. The Create job screen appears.

    Note: To access the Create job screen from the process status page, you can select Create job schedule under Tasks.

  2. In the Job name field, enter a name to help identify the scheduled job.

  3. In the Schedule type field, select the frequency to run the job.

    • To run the job only once, select “One time.” The One-time occurrence frame is enabled.

    • To run the job every day, select “Daily.” The Frequency, Daily frequency, and Duration frames are enabled.

    • To run the job every week, select “Weekly.” The Frequency, Daily frequency, and Duration frames are enabled.

    • To run the job every month, select “Monthly.” The Frequency, Daily frequency, and Duration frames are enabled.

    • To run the job with the SQL Server Agent service, such as if you use the SQL Server Agent service with other tasks, select “Start when SQL Server Agent service starts.”

    • To run the job when enough resources are available on the server, as determined by the Idle condition defined in the SQL Server Agent properties on the server, select “Start when the computer becomes idle.”

  4. To mark the schedule active, select Enabled.

  5. If you select “One time,” under One-time occurrence, select the time and date to run the job.

  6. If you select “Daily,” under Frequency, in the Occurs every [ ] day(s) field, select how often to run the job. For example, select “2” to run the job every other day.

  7. If you select “Weekly,” under Frequency, in the Occurs every [ ] week(s) on field, select how often to run the job, and select the day of the week to run the job.

  8. If you select “Monthly,” under Frequency, in the Occurs every [ ] month(s) on field, select how often to run the job, and then select a calendar date or a general date frequency to run the job.

    • To run the job the same date each month, select Day and, in the [ ] of the month field, enter the date. For example, to run the job on the 15th of the month, enter “15.”

    • To run the job at a general frequency each month, select The and, in the [ ][ ] of the month field, enter the frequency. For example, to run the job of the first Sunday of the month, select “First” and “Sunday.”

  9. If you select “Daily,” “Weekly,” or “Monthly,” under Daily frequency, select whether to run the job one time or multiple times on the day selected under Frequency.

    • To run the job one time on the selected day, select Occurs once at and enter the time of the day to run the job.

    • To run the job multiple times on the selected day, select Occurs every and enter the frequency to run the job, such as “30 minutes.” In the Starting at and Ending at fields, select a time range to run the job at the selected frequency. For example, to run the job overnight during off-hours, enter select a start time of “12:01:00 AM” and an end time of “5:30:00 AM.”

  10. If you select “Daily,” “Weekly,” or “Monthly,” under Duration, in the Start date field, enter the date to start the job schedule and select whether the schedule has an end date. If you select End date, enter the date to end the job schedule.

  11. Select Save. You return to the Job schedules tab. In the grid, the new job schedule appears.

After you create a job schedule for a process, you can update it. For example, you can adjust its frequency. You cannot edit the package to create the job schedule. To edit a job, select it and select Edit.

  1. On the Job schedules tab, select a job and select Edit. The Edit job screen appears. The options on this screen are the same as the Create job screen. For information about these options, refer to Create job screen.

  2. Make changes as necessary. For example, in the Schedule type you can change how often to run the process.

  3. Select Save. You return to the Job schedules tab.

On the Job schedules tab of the status page, you can delete a job schedule of the process. This deletes the scheduled job as well as changes made to it outside the program. To delete a job schedule, select it and select Delete.

  1. On the Job schedules tab, select the job and select Delete. A confirmation screen appears.

  2. Select Yes. You return to the Job schedules tab.