Scheduling Recurring Jobs using Calendars

Objective

After completing this lesson, you will be able to schedule complex recurring jobs using calendars.

Calendar-Based Scheduling

You can address most of your organization's content scheduling tasks with the available recurrence patterns. For example, while there is not a preset recurrence pattern for quarterly, you can easily accomplish this by setting the value for N in the available Monthly option to 3. Sometimes you might need multiple schedules. For example, to run payroll reports semi-monthly on the 15th and final days of each month, you can create one schedule using the Nth Day of Month option and a second one using Last Day of Month.

Calendars make it easy for you to schedule complex recurring jobs efficiently. Calendars allow you to run a scheduled job based on a custom set of dates that are not available with standard scheduling options.

Calendars:
Calendars are useful when you want to run a recurring job on an irregular schedule.
Calendars allow you to create more complex processing schedules, combining special scheduling dates with recurring ones.
For example, to have a report object run every business day except for public holidays, you create a calendar with the holidays marked as "non-run" days. The report object doesn't run on those "non-run" days. SAP BusinessObjects BI Platform 2025 will run the job every day you've specified as a "run" day in your calendar.
Calendars in CMC.
Security on Calendars:
In CMC, administrators can set up as many calendars as you want in SAP BusinessObjects BI Platform 2025.
  • When you apply the calendar to a job, SAP BusinessObjects BI Platform 2025 runs the job on the run dates as scheduled.
  • You can apply calendars to any object that can be scheduled, including report objects, program objects, and publications.

By default, there are no calendars in SAP BusinessObjects BI Platform 2025.

Default Security on a Calendar in CMC:
Once created, a new calendar has to be secured by administrators to allow a principal to use it within a scheduled task.
  • By default, only administrators have access to calendars.
  • The View predefined access level is enough to be able to access calendars in calendar-based scheduling.
User Security on Calendars in CMC.

Calendar Date Selection

Selected Dates:

Administrators can maintain calendars by adding dates to a calendar using several different formats in CMC. They can choose and mix up:

  • Specific Dates (using a yearly, quarterly, or monthly view of the calendar).
  • Recurring Dates (using general formats based on the day of the month or week).
Select Dates option for a Calendar in CMC.

Specific Dates

To add a specific date to a calendar, use the Yearly, Quarterly, and Monthly formats.

The Yearly format displays the run schedule for the entire year. The Quarterly format displays the run dates for the current quarter. You can also view the Monthly format for the calendar, which displays the run dates for the current month. In all three formats, you can change the displayed time range by choosing the previous and next buttons.

You can add specific dates in any calendar format by choosing the day that you want to add. If you wish to add an entire week, choose > in the row header for that week. If you want to run the object for an entire column of time, choose the column title.

Specific dates in a calendar.

For example, if you want a calendar with business days only (from monday to friday) for Q4 2025, you can create a list of these specific dates in a "Business Days Q4 2025" calendar. This calendar will be used for scheduling objects only during these business days. Specific dates are very useful as well when you have some irregular and non-periodic dates to set manually in your calendar.

Recurring Dates

Recurring dates in a calendar.

You can also add recurring days based on the day of the week or the day of the month. To view existing run dates, use the Yearly, Quarterly, or Monthly format; the generic formats are used to add recurring dates to the calendar. To add the recurring days, choose By day of month or By day of week and select the days that you wish to add or remove.

Although you can set a recurring schedule that uses the standard scheduling options, calendars allow you to specify several different recurring run patterns at once. You can also run instances on dates that don't follow the pattern by adding individual days to a calendar.

You can create several calendars that give more calendar-based scheduling options.

Create and Apply a Calendar

In this exercise, you will create and apply a calendar in the SAP BusinessObjects BI Platform 2025.

Summary

  • Calendar-based scheduling allows organizations to handle content scheduling tasks using various recurrence patterns, including complex and irregular schedules.
  • Calendars enable the scheduling of jobs based on custom sets of dates not available with standard options, allowing for more complex processing schedules.
  • Specific dates can be added to a calendar using yearly, quarterly, or monthly views, and recurring dates can be added based on the day of the week or month.
  • Calendars can be applied to any schedulable object in the BI platform, ensuring jobs run on specified "run" days while avoiding "non-run" days like public holidays.
  • Users can set up multiple calendars to provide more flexible calendar-based scheduling options.