You have to complete 4 steps.
1. Create an event
2. Create a script file for database table record count
3. Create the schedule
4. Create a windows task schedule
1- Create an event:
Log on to CMC and create an event.
Go to “System Events” folder and click on “Create an event”
Fill the text boxes. Choose “File” as type and the path of your “ok” file. Note that the “ok” file (which is “f:\a.txt” for this example) is not created yet. The text file will be created by a script mentioned below. The “f” drive is a drive on your BO server.
2- Create a script file for database table record count
Ok. Now we need a script. This script will;
- connect to the database
- check the number of rows in our table
- if there is record which is corresponding to our query, create the “ok” file
You can find an example file with this kind of script as an attachment.
3- Create the schedule
Go to your BI portal and create your schedule. Don’t forget to select your event.
So, your schedule will never run, until there is a file named as “a.txt” on your “F” drive.
PS: Don’t forget that the schedule looks for the “ok” file which is created after the schedule creation time.
4- Create a windows task schedule
The last step is , create a windows schedule task, which automatically runs your script file every hour or quarter or etc. If your ETL process fails there will be no record in your table and the script won’t create the “ok” file “a.txt”. When the ETL process succeed your script will create the “ok” file and your schedule will run.