File based Scheduling of Crystal Reports

scheduling XI Scheduler
1

Hi All,

We are using SAP BO Enterprise Edition XI and I have 20 Crystal Reports with Country Code as Parameter. I have to schedule these reports for 5 countries, each with the corresponding parameter. All reports must be sent automatically per email by BO scheduler and we don’t want to send bulk reports. Additionally my client wants to manage manually, when the reports should run. For this problem I found such a solution:

Reports will be scheduled everyday e.g. at 9 am and at the same time they look for a file to run. If the file is there, then scheduler fires report and sends as email-attachment. Because each report has to be controlled seperately, i will create 100 file based event (20 reports x 5 Countries).

My questions are:

1- If I copy the File to the right place at 18 pm, does the report run? How can I guarantee that the report will run, as soon as the file is available.
2- Does it cause a performance problem to have 100 scheduled jobs in BO Server at the same time, which are waiting for different files.
3 - I have to delete the event-Files after each run. Is it possible to do this with BO or do i need a batch process.

Thank you in advance and best regards

ibob (BOB member since 2010-02-03)

2

The report will run if the file arrives at 18:00. XI will look for the file to arrive up to 24 hours after the scheduled instance is set to run. You cannot guarantee the job will run as soon as the file arrives because all your job servers may be busy.

There will be some overhead with the event server scanning directories for so many files, but I don’t think it will be noticeable. You may think about increasing the scan interval in the CMC for this server.

BOE does not have a native way to do this so a batch process is needed. Many people create a program object and schedule it in XI to delete trigger files.

BoB LoblaW :us: (BOB member since 2007-10-23)