Is there an out-of-box way to automagicly report , using RC, the last time that an ETL PF Ran?
Or, do I do something like this,? If so, what are the items in the {} brackets?
TABLE FILE {ETL LOG FILE}
BY HIGHEST 5 {ETL END TIME}
WHERE MY_PF EQ 'DOUGS_ETL_PF'
END
Thanks, DougThis message has been edited. Last edited by: FP Mod Chuck,
In FOCUS Since 1983 ~ from FOCUS to WebFOCUS. Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
February 06, 2019, 03:31 PM
Doug
All that I really want to get is the date/time stamp of the last execution of an ETL PF.
February 12, 2019, 02:43 PM
FP Mod Chuck
Doug
Try this..
TABLE FILE ETLLOG SUM REQ_NAME BY HIGHEST DATE WHERE REQ_NAME EQ 'DOUGS_ETL_PF' ON TABLE PCHOLD FORMAT HTML END
The master file for the etllog can be found in the following directory \ibi\srv82\home\catalog
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
February 12, 2019, 03:52 PM
Doug
That's what I was hoping for... However, all I get back for 'REQ_NAME' is RMUDBLOD, rmusavlg, and blanks with seemingly good timestamps (20180923052409000000).
The subject line of than email is something like this: "(ICM18764) Request kgp_doug/lee_master_delta_pf failed; RC = 60002"
TABLE FILE ETLLOG
SUM REQ_NAME
BY HIGHEST DATE
BY REQ_NAME
-*WHERE REQ_NAME EQ 'DOUGS_ETL_PF'
ON TABLE SET BYDISPLAY ON
ON TABLE PCHOLD FORMAT HTML
END
February 12, 2019, 07:14 PM
FP Mod Chuck
Hmmmmm that is the only field other than JOBNAME in that master and JOBNAME is not helpful. I saw valid values for REQ_NAME when I run it on my system
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
February 13, 2019, 10:20 AM
Doug
I'm not sure. But, there may be something that can be added to the ETL process itself.
I gotta learn more about the ETL processing...
February 18, 2019, 11:08 AM
Doug
I'm checking to see if there's something that can be added to the ETL process itself.
I'm open to any suggestions... insight...
February 19, 2019, 12:44 PM
FP Mod Chuck
Doug
There is a second table that may help. I see the same request name as I did in the etllog file though, but I wanted to make you aware of it..
TABLE FILE ETLSTATS SUM S_REQ_NAME BY HIGHEST 1 STAT_STRT_T ON TABLE PCHOLD FORMAT HTML END
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
February 20, 2019, 09:05 AM
Doug
Thanks for the ETLSTATS... But, we're still not there yet.
I'll give this post a little more time before I close it.
February 20, 2019, 09:34 AM
Marina
Doug, The best way to obtain a response to this type of questions is to open a Hottrack case.
Thanks, Marina.
February 21, 2019, 08:42 AM
Doug
Yep, "The best way to obtain a response to this type of questions is to open a Hottrack case."
"I'll give this post a little more time before I close it." I'll do that when my priorities permit, Maybe this week.
In FOCUS Since 1983 ~ from FOCUS to WebFOCUS. Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206