As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at email@example.com and provide your corporate email address, company, and name.
WF 126.96.36.199 What is needed and how would I run an RC job via a web service?
I have a job that runs once a month but the end user wants this to run every time they update the db2 table. This could happen at night or over the weekend so they want to schedule on their end with something like IWS or other web service.
Thanks JVThis message has been edited. Last edited by: FP Mod Chuck,
You can do this with what you have, and setting a semaphore. Use an onChange trigger on the table to set a value somewhere, then have ReportCaster interrogate that value and only issue the report if it is set. RC can use a Post-action fex to clear the value.
Set RC to run the job every hour, every ten minutes, every minute as required by your business case.
Option 2 -- write to the BotSched table! That's what ReportCaster gets its job information from. I've done it, works like a dream. Make sure you test very well.
Posts: 1012 | Location: At the Mast | Registered: May 17, 2007