{Template_Oracle:hours_since_last_archivelog_backu p.last(0)}>2 and
{Template_Oracle:hours_since_last_archivelog_backu p.time()}>090000 and
{Template_Oracle:hours_since_last_archivelog_backu p.time()}<180000
That's the trigger logic.. basically, if it's been 2 hours since an archivelog backup and the time is between 9AM-6PM, trigger.
At least that's how it used to work.. until I upgraded to 2.4
Any ideas why this isn't working?
The trigger test works when I put in test values.. yet I get alerts when last(0) is > 2 and the time is outside of this window.
Brian
{Template_Oracle:hours_since_last_archivelog_backu p.time()}>090000 and
{Template_Oracle:hours_since_last_archivelog_backu p.time()}<180000
That's the trigger logic.. basically, if it's been 2 hours since an archivelog backup and the time is between 9AM-6PM, trigger.
At least that's how it used to work.. until I upgraded to 2.4
Any ideas why this isn't working?
The trigger test works when I put in test values.. yet I get alerts when last(0) is > 2 and the time is outside of this window.
Brian