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

You must be logged in to post a comment.