OraFAQ Forum: Server Administration » DBMS Scheduler jobs are not running

Home » RDBMS Server » Server Administration » DBMS Scheduler jobs are not running (10.2.0.4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DBMS Scheduler jobs are not running [message #488983]

Wed, 12 January 2011 11:41

Anand Ramaswamy
Messages: 111
Registered: January 2005

Senior Member

Hi,
I have scheduled few jobs (scheduled for each day) which has not run today, which was running successfully till yesterday. When I query dba_scheduler_jobs, i could see last_run_date as yesterday's date 6am and next_run_date is still showing today's date and time (it should show tomorrow's date/time).

Regards,
ARS

Report message to a moderator

Re: DBMS Scheduler jobs are not running [message #488985 is a reply to message #488983]

Wed, 12 January 2011 11:49

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

HAveyou looked at the log, DBA_SCHEDULER_JOB_LOG and DBA_SCHEDULER_JOB_RUN_DETAILS ?

[Updated on: Wed, 12 January 2011 11:50]

Report message to a moderator

Re: DBMS Scheduler jobs are not running [message #488987 is a reply to message #488985]

Wed, 12 January 2011 11:55

Anand Ramaswamy
Messages: 111
Registered: January 2005

Senior Member

Hi John,
I did see these two views, it contains information for yesterday's (11-jan-2011) run and not about today's (12-Jan-2011)run.

Regds,
ARS

Report message to a moderator

Re: DBMS Scheduler jobs are not running [message #490081 is a reply to message #488987]

Thu, 20 January 2011 20:49

ebrian
Messages: 2794
Registered: April 2006

Senior Member

As John mentioned, did you check the alert log?

Report message to a moderator

Previous Topic:	Oracle JOB
Next Topic:	Issue in Manual DB creation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 08:36:49 CST 2024