Hello all, we are in need to update and distribuite xi documents only when a particolar Data Base job run. So the data Base got updated, and the DB batch job itself create the event.txt file to start the XI scheduler process.
So the steps are:
We have a DB2 data base updated when needed
After the DB2 update is complete we need to refresh all our corporate documents using XI scheduler in an authomatic way.
We are able to do so using the procedure described in
So the DB batch jobs create the specific file events.txt, starting the BO scheduling.
The problem is that after BO START to refresh the report we need to DELETE the file events.txt (generated by the DB2 job), so The XI scheduler update the corporate documents only ONE time (cuz it take about 2 days…) and restart ONLY if a new events.txt is created.
So we need a way to interact with operating system between Business Objects and windows itself. After the scheduler operation is done we need that BO delete that file!
Are you running on Windows or Unix? How often does the DB job run? How long does it take to run?
If the DB job runs longer than the Polling Interval on the Event Server, can the job delete the file before it starts?
If the job runs once a day or less, another option would be to have a scheduled process that deletes the file every day. In Windows I would do this with a .bat file that is run through the Windows Scheduler.
It’s Windows , DB job run every month and it takes some days.
When the DB job is finished, it create the file.txt on a specific path and this start the schedular trigger by event server of BO XI r3.
Our problem: this month DB job start random during the month itself, so we don’t have a fixed start date and we can’t create a .bat file that is run through the Windows Scheduler. We simply need that BO after the auto report update (scheduling proces) delete the triggering file .txt…we really dont know how =-/
(BOB member since 2007-04-16)
(BOB member since 2007-01-22)