Scheduling reports during specified hours 1

[mgpeters]

Environment: CR/CE 10; Oracle direct connect

I would like to schedule reports to run every 30 min's during our business hours (7am - 5pm). I don't want to have the reports running every 30 min all night long.

What is the best way to do this?

 

[jedownsjr]

You could create multiple weekly schedules (check Mon-Fri but not Sat or Sun), one schedule for each half hour.

For example: Weekly (check Mon-Fri) at 8:00 AM. This would run each weekday at 8:00 AM, one time. Then create another weekly schedule (again, check Mon-Fri) at 8:30 AM and so on until you have scheduled every 1/2 hour through the end of your business day.

It's cumbersome, but that is the only solution I have been able to think of so far using only CE/BOE.

Alternatively, you could schedule your report to run on an event (such as a file event) and depend on some other application with more scheduling options to delete/replace a file to trigger the event.

 

[mgpeters]

Thanks. I was hoping there was a more automated way to do this directly in CE

 

[ShortyA]

A file event is the simplest method in my own personal experience.

If you create a .bat file:

Rem My batch file
ren c:\myfolder\mytrigger.txt c:\myfolder\mytrigger.ats
sleep 300
rem to let CE see the event and set off the report
ren c:\myfolder\mytrigger.ats c:\myfolder\mytrigger.txt
Exit
Rem End of My batch file

We used the AT command on the CE server to run this during operational hours with the report set to run every 30 mins or so once triggered by the file event for mytrigger.txt

Hope this helps.
ShortyA

 

[mgpeters]

Thanks ShortyA! I've never done anything with a file trigger before, but you made it easy.