Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

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


Ben Maxwell

Recommended Posts

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

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

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...