REM RMINC_manager_down.sql
REM
REM Copyright 2000, All Rights Reserved, Reed-Matthews, Inc.

REM We run this program from CRON every 5 minutes.  It's purpose is to tell us if
REM the concurrent manager's internal manager is down.  If it is
REM down, then we need to take steps to turn it back on.
REM 
REM user must be applsys or sys

col v1 new_value v1
set term off;
set echo off;
set heading off;
set feedback off;
select '2' v1 from
applsys.fnd_concurrent_queues
where concurrent_queue_name = 'FNDICM'
and running_processes = 0;
echo &v1
exit &v1