Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Automated way to find ODI package runtime,amount of aborted PKGs for specific time period

MaheshGxJun 14 2013 — edited Jun 14 2013

Hi,

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.


Thanks,

Mahesh

Comments

Nigel Deakin-Oracle
The JMS specification doesn't offer a way to explicitly purge a destination (delete all its messages), though your chosen JMS provider might off a non-standard way of doing this.

You could of course simply consume all the messages in a loop.

If you want to use message expiration, don't try using setJMSExpiration on the Message. That method is not for the purpose you might think (see the javadocs). Instead use one of the following methods on MessageProducer:

void setTimeToLive(long timeToLive)
Sets the default length of time in milliseconds from its dispatch time that a produced message should be retained by the message system.

void send(Destination destination, Message message, int deliveryMode, int priority, long timeToLive)
Sends a message to a destination for an unidentified message producer, specifying delivery mode, priority and time to live.

timeToLive is in milliseconds.

Nigel
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 12 2013
Added on Jun 14 2013
4 comments
331 views