Hi,

This week I had a problem with my scheduled standard report in caster that run with no refreshed data because the extraction procedure on the i5/as400 has not been completed successfully.

I saw in caster that we could have pre and post fex to a scheduled report. But my procedure is a pure as400 object that runs many sql statments but also other as400 commands.

What is your best recommandation? Is any of you client has to do so?

Thanks for your help.

This message has been edited. Last edited by: Kerry,

Have a look in the Developer Centre at an article called "How to Automatically Delay ReportCaster Jobs".

You can get to the Developer Centre via the first bread crumb link at the top of the page and then head for the Tips and Techniques link on the left hand side of the resultant web page.

My personal preference on this sort of thing is to check for the file existence via a precedent fex and to reschedule the caster job for ten minutes time before using KILL_RPC. Don't forget to set it back to the next run time in a postscript fex as necessary.

T

Thanks Tony,

I will have a look part time. Excellent if there is a solution and if it is faisable. Did you do it once?

Should I close it?
Again thank you.

You are welcome. It a good source for many techniques etc. and, yes I have used a similar technique before to circumvent the inability to schedule reports on disparate dates that do not conform to "normal" frequencies such as "first day of month" etc. If your accounting periods are sporadic this method can get you out of a hole!

T