We have a scheduled activity for execution of packages daily.
1. I wanted to know if there is any automated way to find execution time of packages say using query or so.
2. Moreover, per week we would also like to extract the amount of aborted PKGs so that we can draw a baseline and evolution graph about it.
I am assuming that whatever we see in the ODI Console can surely be extracted from the ODI repository.
Anyone know if we can find any specific package execution time and aborted package names in specific time say a week or so.
Any pointers regarding this would be appreciated.
For the high-level view, you can directly use the SNP_SESSION table in your workrepository.
SELECT * FROM SNP_SESSION s ORDER BY SESS_BEG DESC
The column SESS_DUR gives you the execution time and column SESS_STATUS tells you if it was successful or finished with error.
Here are the status code :
'E' : Error
'D' : Done
'W' : Waiting
'M' : Warning
'R' : Running
'Q' : Queued (not sure about this one).
You will also find the error message (if any), the context used, the agent used, ...
Hope it helps.