Is there a method to cause a report caster schedule to run outside of the normal timed schedule? I run SQL Server and when a SQL Server Job step is complete, I would like it to start a schedule in report caster so that the report would be delivered as soon as possible.

This message has been edited. Last edited by: <Kathryn Henning>,

I had a similar situation where accounting was always contacting us to rerun reports generated from report caster at month end. The problem was we were never quite sure when they would request this or when we could get around to running it for them.
To resolve this i created a SQL table RUNREPORT that is keyed by the report name that contains a flag to run the report if set to 1. I then built front ends in html for the reports that basically all they do is set the flag.
In report caster I created a job that runs every 15 minutes and checks the flag. If set to 1 it runs the report and changes the flag back to 0. If the flag is 0 it just drops out.
So if you able to set the flag when the Server Job is complete it would work.
It's not a perfect solution but at least the user knows they will have the report within 15 minutes and it works.
Hope this helps.

yep. i agree w/ Glenn. we use a PRE-PROCESSING fex (you know how to do that? edit schedule, tasks, click on task and click edit, advanced button, procedures tab, then enter the name of the fex you want run BEFORE the job).
In this little pre-processing fex (sitting in the same app directory),
you test whatever status condition you want
and if you get a no-go condition then you
-SET &&KILL_RPC = 'Y' ;
and that's it, the job won't run
'N' is the default
you can specificaly set
-SET &&KILL_RPC='N' if you want, when you get a GO condition, and your job will run like normal.

(see page 140 in the WF Keysheet for syntax of the KILL_RPC command)

Can you get SQL Server to execute a BAT file (Windows server) or script (on Unix) when it's done doing its thing? We have our scheduler kick off a BAT file to execute ReportCaster jobs based on the other scheduled jobs as dependencies, and it works out nicely.

Doug that is exactly what I want to do. What is in your .BAT file? What do you run to make the ReportCaster Job execute?

Thanks for the other suggestions.


Steve

Steve,

I believe there is a requirement to what Doug is saying and that is that the SQL Server has to be on the same box as WebFOCUS. So, if it not then you heed to do what Glenn C. is saying.