When a job is run from the data migrator, is there a way to ...

[Manoj Chaurasia]

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.

[Ben Maxwell]

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.

[David Beagan]

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.

[Ben Maxwell]

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.