Focal Point
[CLOSED] Get the Last Run Time for a PF

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

February 06, 2019, 12:38 PM
Doug
[CLOSED] Get the Last Run Time for a PF
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, Doug

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


   See you at Summit! In FOCUS Since 1983 ~ from PC FOCUS to WebFOCUS.
   Currrently using 8204 Gen 48 in Test and Production.
   KGPCo at CenturyLink. October 2017 to Present...
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"

Here's a few lines.
20190211210021000000 RMUDBLOD RMUDBLOD 
20190211210002000000 RMUDBLOD RMUDBLOD 
20190211210002000000 rmusavlg rmusavlg 
20190211210001000000 rmusavlg rmusavlg 
20190210210018000000 RMUDBLOD RMUDBLOD 
20190210210017000000 RMUDBLOD RMUDBLOD 
20190210210002000000 RMUDBLOD RMUDBLOD 

Here's the code:
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.


   See you at Summit! In FOCUS Since 1983 ~ from PC FOCUS to WebFOCUS.
   Currrently using 8204 Gen 48 in Test and Production.
   KGPCo at CenturyLink. October 2017 to Present...