Manoj Chaurasia Posted September 10, 2021 Share Posted September 10, 2021 Benjamin DataMIgrator creates a FOCUS database called ETLSTATS that you can create a procedure (fex) against. There are two fields of interest to you S_REQ_NAME which is the data flow name and STAT_END_T which is a date time stamp of when it completed. You will have to copy the etlstats.mas file from the ibisrv82homecatalog directory to one of your app folders in order to access the etlstats focus database. Link to comment Share on other sites More sharing options...
Ben Maxwell Posted September 10, 2021 Author Share Posted September 10, 2021 Thanks Chuck - I am going to have my IT guy look into this, and well see if we can write a simple fex to extract this timestamp. Link to comment Share on other sites More sharing options...
David Beagan Posted September 10, 2021 Share Posted September 10, 2021 Maybe you are looking for something like this. Create a set_completion_time.fex. set_completion_time.fex -SET &Completion_Time = DT_FORMAT(DT_CURRENT_DATETIME(MILLISECOND), 'HYYMDs'); - &Completion_Time SAVE baseapp/completion_time.fex Whenever your job is complete, call the set_completion_time.fex. It will create a fex that is something like: baseapp/completion_time.fex -*CURRENTLY DEFINED VARIABLES STARTING WITH 'Completion_Time': -SET &Completion_Time = '2021/09/10 15:31:48.524'; Now your dashboard just needs to call the baseapp/completion_time.fex to get the &Completion_Time variable set to the time you want to display. Link to comment Share on other sites More sharing options...
Ben Maxwell Posted September 10, 2021 Author Share Posted September 10, 2021 When a job is run from the data migrator, is there a way to capture the time stamp by writing a WebFocus fex i.e. We have a Lawson feed set to run overnight via the Data Migrator. Id love to post the completion time of this job on my dashboard so that the users would know the vintage of the data. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now