Monitoring Workflow notifications
All,
We are seeing the our inbound workflow notifications agent is failing in connecting to the IMAP Server.
We are looking to monitor our inbound and outbound communications using the following SQL. This will count how many message ( inbound and outbound ) have been over a 10 minute period.
My Question is -
Is this an appropriate way to monitor Workflow notifications or is there a better way to do this other
SQL
select to_char(enq_time,'YYYY-MM') YYYYMM
,to_char(enq_time,'DD') DD
,to_char(enq_time,'HH24') HH
,substr(to_char(enq_time,'MI'),1,1)||'0' MI
We are seeing the our inbound workflow notifications agent is failing in connecting to the IMAP Server.
We are looking to monitor our inbound and outbound communications using the following SQL. This will count how many message ( inbound and outbound ) have been over a 10 minute period.
My Question is -
Is this an appropriate way to monitor Workflow notifications or is there a better way to do this other
SQL
select to_char(enq_time,'YYYY-MM') YYYYMM
,to_char(enq_time,'DD') DD
,to_char(enq_time,'HH24') HH
,substr(to_char(enq_time,'MI'),1,1)||'0' MI
0