[SOLVED] How to extract job with task details in excel sheet through report caster.
Dear Team,
How to extract all scheduled job with task details in excel sheet through report caster.
Thanks Veeramani KThis message has been edited. Last edited by: FP Mod Chuck,
WebFOCUS 8 Windows, All Outputs
July 26, 2018, 09:17 AM
Efrem
In WebFOCUS 8203, we added a WebFOCUS Client adapter.
Using this adapter, there is a way to extract a ReportCaster schedule to Excel.
You would need to be licensed for the WebFOCUS Web Services Enablement option.
If you have the REST adapter licensed, that also can be used.
Efrem
July 26, 2018, 09:39 AM
Veeramani Karuthapandian
Hi EFrem,
In WebFOCUS Version 7.7.03 - Any other way to retrieve these information's through RC
Thanks, Veeramani K
quote:
Originally posted by Efrem: In WebFOCUS 8203, we added a WebFOCUS Client adapter.
Using this adapter, there is a way to extract a ReportCaster schedule to Excel.
You would need to be licensed for the WebFOCUS Web Services Enablement option.
If you have the REST adapter licensed, that also can be used.
Efrem
WebFOCUS 8 Windows, All Outputs
July 26, 2018, 09:43 AM
BabakNYC
7.7.03 is 6 or so years old and has a completely different repository.
WebFOCUS 8206, Unix, Windows
July 26, 2018, 09:48 AM
Efrem
In any release post WebFOCUS 8, this can be handled with the REST adapter and WebFOCUS RESTful Web Services.
A ReportCaster expert might know if there's a way.
Efrem
July 26, 2018, 01:30 PM
MartinY
It does depend if your RC has been installed under a sql DB. In so you can have sql script to query the RC DB or have synonym defined on that DB and use WF to query. Table's name should start with "BOT" but I can't say how your DB is named.
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
July 31, 2018, 04:21 AM
Veeramani Karuthapandian
Using the below code, I am able to retrive the job details which are scheduled in report caster.