This is an awesome feature in BI Publisher 11g but I do not hear a lot of noise about it so let me create some.
I'm talking about Event triggers in BI Publisher 11g. Using event triggers, we can conditionally stop the delivery of a report. We will see the process of skipping schedules in this article.
- Create a data model for a BIP report.
- a. Define a dataset
- b. Define a Event trigger. Select Schedule as the Type. I have put the following query in my event trigger.
Run the report immediately by selecting the Run Now button on the same schedule tab and submitting the job.
Open the report again and check the job execution history as shown below.
You will see a success status as shown below.
Clearly, this query isn't going to return records. Hence we expect the schedule to be skipped.
- Set a schedule again, once the SQL of the Event trigger has been changed.
- You will see that the schedule has been skipped as shown in the screenshot below.