SAP Data Services (SDS) has two options for scheduling jobs – its own scheduler or using the SAP BusinessObjects Enterprise (BOE) scheduler
BOE has the capability for one schedule to be dependent on another – via the triggering of a schedule event.
Using this approach report schedules can be dependent on an SDS job completing.
1. Ensure the necessary integration is set up between SDS and BOE
In the SDS Management Console | Administrator | Management | CMS Connection, enter in the top section the BOE account that SDS uses to communicate with BOE and below the network account that BOE will use to run the SDS job:
2. Create the event which the SDS job will trigger and the report schedule(s) will wait for
Select Type = Schedule, enter a name, select Result = Success and enter OK.
3. Schedule the SDS Job
Create the schedule in SDS Management Console | Administrator | Batch (select your repository) | Batch Job Configuration | Add Schedule:
Ensure the schedule is set to use the BOE Scheduler, complete the relevant entries and selct Apply:
4. Schedule the report to be dependent on the triggering of this event
In the BOE CMC go to Folders | Navigate to your report | Schedule | Events. Add the schedule event you created in to the ‘Events to wait for’ window and hit Schedule:
5. Navigate to the scheduled SDS job in the BOE CMC to configure it to trigger the event.
In the BOE CMC go to Folders | Data Services. This is where SDS schedules are stored in BOE – as Program objects. The text file contains the configuration setting.
Right click on the Program object that represents the SDS schedule and select Properties:
If you expand the Schedule option on the left and go to Program Logon you can see the account you configured in the SDS Management Console that will be used to run the programme.
Next select Events. Add the schedule event you created to the ‘Events to trigger on completion’ window in the bottom right. Then click Schedule.
You will see there are now two pending schedules, the original one added by SDS and the modified one with the event trigger added:
6. The schedules run.
When the time dependency you set in SDS Management Console is met, the schedules will run (NB the BOE Job Server service runs Program jobs):
The success of the schedule triggers the schedule event which in turn triggers the report schedule. Go to the report history to view the schedule status: