job scheduler
138002Jan 29 2009 — edited Feb 2 2009Hi,
We have oracle 10g and we scheduled some jobs using dbms_scheduler. When I check the status of some the run jobs some of the job status is STOPPED. We didn't stopped those jobs. I want to find out why the status is STOPPED and what could have caused this. Can some one through some light on this?
JOB_NAME OWNER STATUS COMPLETION_DATE RUN_DURATION
-------------------- --------- -------- -------------------- --------------------
ANALYZE_JOB1 MAINTAIN STOPPED 09-JAN-2009 07:14:14 +000 05:14:14
ANALYZE_JOB2 MAINTAIN STOPPED 08-JAN-2009 08:14:29 +000 05:14:29
ANALYZE_JOB3 MAINTAIN STOPPED 02-JAN-2009 09:13:55 +000 05:13:55
Thx