Job Logs for most recent execution (XMETA SQL)

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
jackson.eyton
Premium Member
Premium Member
Posts: 145
Joined: Thu Oct 26, 2017 10:43 am

Job Logs for most recent execution (XMETA SQL)

Post 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.
-Me
PaulVL
Premium Member
Premium Member
Posts: 1309
Joined: Fri Dec 17, 2010 4:36 pm

Re: Job Logs for most recent execution (XMETA SQL)

Post 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.
Post Reply