Home » RDBMS Server » Server Administration » scheduler job
scheduler job [message #383830] Fri, 30 January 2009 08:22 Go to next message
caprikar
Messages: 226
Registered: March 2007
Senior Member
We have jobs running using dbms_scheduler in oracle 10g(HP-UX). Some of the jobs were showing status as STOPPED. I checked the alert logs and there is no error and this job is not attached to any window. Here is the job status and reason when I query from dba_scheduler_job_run_details

JOB NAME OWNER    STATUS   COMPLETION DT        RUN DURATION        REASON
--------------------------------------------------------------------------------------------------------
JOB_1   MAINTAIN  STOPPED  30-JAN-2009 02:28:23 +000 00:28:23 REASON="Job slave process was terminated"

Can someone tell me what could be the reason?
Re: scheduler job [message #383847 is a reply to message #383830] Fri, 30 January 2009 12:45 Go to previous message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Somehow your ora_cjq0 Oracle process was terminated, either by an error, or someone killing it out. Should be in the alert log though I would think.
Previous Topic: end of file communication channel
Next Topic: Upgrading from 9i to 10g
Goto Forum:
  


Current Time: Sat Dec 03 03:43:48 CST 2016

Total time taken to generate the page: 0.08037 seconds