Scheduling Reports based on Event - multiple times a days

[system]

Hi,

Can someone help us, we want to schedule the reports based on file based event (just file only… NO time frame)…

Say, Our ETL process runs 4 times or 5 times or even 10 times a day (there is no fixed interavel) and drops a trigger file ETL_COMPLETE.TXT file on a shared location, then we want to kick-off our BO schedule based on that file.

How do we do it?

Thanks,
VJ

---

vijaykollu (BOB member since 2003-05-08)

[system]

Are you after Desk_I or Web-I reports??

Desk-I:

Use macros by mentioning interval and based on that Schedule the reports(File based events).

Thanks

---

BOCP (BOB member since 2007-07-02)

[system]

WebI reports…

---

vijaykollu (BOB member since 2003-05-08)

[system]

Hi VJ,
Use FileBased Events to trigger the Schedule when a file is placed on a server. You need to implement a process to delete the file soon after its success or Failure.
Here is the notes what i have suggessted in other thread.

@forgotUN

1. Created a file based event “A” which is triggered up on the existence of the text file.
2. Created a program object which runs the batch file located on local Drive
   (This batch file deletes the file placed by ETL)
3. Scheduled the report with event wait as “A” and Event to be triggered on completion as “B” (B is a scheduled event created for success or failure)
4. Scheduled the program object to wait for the Scheduled Event “B”
   This way whenever the text file appears in the said location, Event A is fired and report schedule starts and up on completion of the report schedule(Success or failure) it fires a scheduled event B which will Schedule Program object which deletes the text file.
   -Satish

Thanks
-Satish

---

forgotUN (BOB member since 2006-12-13)