Job Logs for most recent execution (XMETA SQL)

[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.

[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.

[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