Home Code Snippets Oracle Reference Oracle Functions Oracle Error Codes Forum Oracle Jobs Oracle Blogs

Never trust your process monitor.  On occasion, you'll need/want to bounce your process scheduler* and quick check of process monitor will ensure that you won't wack any running jobs … but beware, the process monitor page can and will lie to you.  Use the following SQL (current as of PT 8.4X) to query the database to actually see what's running.  

(* bouncing PRCS to remove file and memory cache is not, always, in my opinion, needed as it was a few years ago; however, it's undenieable effective at ruling out cache issues).

Quick and dirty SQL to do this:

set echo on feed on time on;
set pagesize 50000;

select PRCSNAME
,oprid
,decode(RUNSTATUS,1,'Cancel',2,'Delete',3,'Error',4,'Hold',5,'Queued',6,'Initiated',7,'Processing',
       8,'Cancelled',9,'Success',10,'Not Successful',11,'Posted',12,'Unable to post',13,'Resend',
      14,'Posting',15,'Content Generated',16,'Pending',runstatus) "RUNSTATUS DESC"
,PRCSTYPE   
,to_char(RUNDTTM,'MM/DD/YYYY HH24:MI:SS') "RUNDTTM"
,to_char(BEGINDTTM,'MM/DD/YYYY HH24:MI:SS') "BEGINDTTM"
,(enddttm-begindttm)*1440
from     psprcsrqst
where RUNSTATUS in (6,7)
/

 

This entry was posted in Uncategorized. Bookmark the permalink. Follow any comments here with the RSS feed for this post. Post a comment or leave a trackback: Trackback URL.

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Spam Protection by WP-SpamFree