Job Logs for most recent execution (XMETA SQL)
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 145
- Joined: Thu Oct 26, 2017 10:43 am
Job Logs for most recent execution (XMETA SQL)
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.
-Me
Re: Job Logs for most recent execution (XMETA SQL)
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.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Job Logs for most recent execution (XMETA SQL)
There are sample queries in the Knowledge Center that you could adapt.
https://www.ibm.com/docs/en/iis/11.7?to ... s-database
https://www.ibm.com/docs/en/iis/11.7?to ... s-database
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.