|
[ADSM-L] SQL command to query Sessions with MediaWait or Idle
2008-12-04 23:15:14
Hello all
I am trying to figure out an effective way to get alerted if a backup
job is idle or not proceeding due to a MediaWait state..... I want it
to have the smarts to maybe only alert me if it finds the same
successive node has been in the same MediaWait state for a predetermined
period (eg an hour) - given that I am aware at different times an
occasional 'mediawait' warning is just part of normal function....
What is the best way of doing this? I am thinking either running a SQL
query of some sort to do this, then fire an email or netsend to someone
- OR use SNMP..
Would welcome any suggestions or hints?
<html>
<body>
<font face="arial" color=#808080 size="-2"><img
alt="Santos Logo" src="http://www.santos.com/library/logo.gif";>
<br>Santos Ltd A.B.N. 80 007 550 923<br>
Disclaimer: The information contained in this email is intended only for the
use of the person(s) to whom it is addressed and may be confidential or contain
privileged information.
If you are not the intended recipient you are hereby notified that any perusal,
use, distribution, copying or disclosure is strictly prohibited.
If you have received this email in error please immediately advise us by return
email and delete the email without making a copy.</font>
<font face="arial" color=#008000 size="-2">Please consider the environment
before printing this email</font>
</body>
</html>
|
|
|
![http://www.santos.com/library/logo.gif"](http://www.santos.com/library/logo.gif"){kind=link}