Page 1 of 1
Job Logs for most recent execution (XMETA SQL)
Posted: Tue Oct 12, 2021 10:43 am
by jackson.eyton
I am working on writing a query to pull the most recent job logs from any given job in a specific project, where that jobs completed status is anything other than OK (no warnings etc). Figured I might as well post here in case someone has already done this, otherwise I will post the code here once completed.
Re: Job Logs for most recent execution (XMETA SQL)
Posted: Tue Oct 12, 2021 10:48 am
by PaulVL
Personally I would use DSODB tables to identify the latest project/job/status and then follow up with a dsjob -logdetails extract to get the logs.
I would avoid direct queries to xmeta because a bad user written script could impact your production ETL flow.
Impacting DSODB will not halt your ETL flow.
Re: Job Logs for most recent execution (XMETA SQL)
Posted: Fri Nov 05, 2021 2:38 am
by ray.wurlod
There are sample queries in the Knowledge Center that you could adapt.
https://www.ibm.com/docs/en/iis/11.7?to ... s-database