Custom alerts for Concurrent Manager goes down

In previous post (http://oraclesystemanalyst.blogspot.com/2011/03/concurrent-manager-key-tables.html)
You've been familiar with Key table in Concurrent management .
In this post I will review the issue that many DBA admin faced :  one of the services of concurrent manager down . Whatever people usually do is that go to form and find the query:

SELECT RUNNING_PROCESSES ,CONCURRENT_PROCESSES
    FROM fnd_concurrent_queues_vl
   WHERE enabled_flag = 'Y'

But the issue is that RUNNING_PROCESSES is not show a actual process amount so for find the solution i found following trick :

for set alerting when one services is down to specific persons following steps should meet:

1. Find  APPLICATION_ID(*) and CONCURRENT_QUEUE_ID (**) from fnd_concurrent_queues_tl  table.

2.  Replace in following query to find count (*)

         Select count(*)
         from gv$session GV, fnd_concurrent_processes P
        where
              GV.Inst_id = P.Instance_number
          And GV.audsid = p.session_id
          And (Process_Status_Code not in ('S','K','U'))
          And ( Queue_Application_ID = * AND
        Concurrent_Queue_ID =** )

3. if the count(*) return any value the process is up otherwise it is down or it is restarting .

4. Use Microsoft  reporting services or other tools for sending alerts .