Focal Point
[SOLVED] Running RC job via web service

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7427096496

October 26, 2020, 05:21 PM
Jveselka
[SOLVED] Running RC job via web service
WF 8.1.0.5
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
JV

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8105m
Windows, All Outputs
October 26, 2020, 05:54 PM
Waz
Check out the documentation.
This is the RESTful Web Services documentation for 8105M.
WebFOCUS Release 8.1 Version 05M

Check out Running a Schedule.

Also you will need to issue a login request first


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

October 26, 2020, 06:29 PM
FP Mod Chuck
Jveselka

Your site has to have the WebFOCUS Web Services enablement option licensed. Waz has given you the link to the doc if you to.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
October 26, 2020, 07:42 PM
Jveselka
@FP MOD CHUCK
Where do I go to see if we have this license?


WebFOCUS 8105m
Windows, All Outputs
October 27, 2020, 04:41 AM
Frans
You can see it in the administrationconsole under license.

But I think in this case you dopn't need a webservice, you can use an Alert to add a check on the db table:
Alert


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
October 27, 2020, 04:33 PM
John_Edwards
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.