OraFAQ Forum: Server Administration » Database Jobs are not working

Home » RDBMS Server » Server Administration » Database Jobs are not working

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

Database Jobs are not working [message #149141]

Wed, 30 November 2005 05:35

guyj
Messages: 31
Registered: September 2005

Member

Hi All

We have a database with 16 backend jobs which are running under deferent users. Those jobs are not working now, but earlier those were working perfectly. Jobs are not broken either. I couldn’t find any errors in the alert log or any trace files regarding this issue.

Our database version is 9.0.1.4 and we have set the job_queue_processes into 3.
Please help me to solve this issue.

Report message to a moderator

Re: Database Jobs are not working [message #149165 is a reply to message #149141]

Wed, 30 November 2005 07:10

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

Query DBA_JOBS and DBA_JOBS_RUNNING to see if you jobs are executed or not:

select job, schema_user schema,
       to_char(last_date, 'DD-MON-YY HH24:MI') "LAST_RUN",
       to_char(next_date, 'DD-MON-YY HH24:MI') "NEXT_RUN", 
       failures, 
       decode(broken, 'N', 'NO', 'Y', 'YES', broken) broken, what
from   sys.dba_jobs
/

select sid, job, failures, last_date, last_sec, this_date, this_sec
from   sys.dba_jobs_running
/

Best regards.

Frank

Report message to a moderator

Re: Database Jobs are not working [message #149257 is a reply to message #149165]

Wed, 30 November 2005 20:44

guyj
Messages: 31
Registered: September 2005

Member

Hi Frank,

Thanks for the Reply.I went through those views. One job is marked as broken. And others are not broken but next date showed as 05/31/2004. Then I rescheduled those, but no success. I queried dba_jobs_running and nothing was there.

Report message to a moderator

Re: Database Jobs are not working [message #149497 is a reply to message #149257]

Fri, 02 December 2005 01:12

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

After rescheduling the jobs try to manually run the job once from the system user ..

(if the job is scheduled from other user ..then using the system user you can run this way)

exec dbms_ijob.run(jobno);

-Sai Jeedigunta

Report message to a moderator

Re: Database Jobs are not working [message #149503 is a reply to message #149497]

Fri, 02 December 2005 01:21

guyj
Messages: 31
Registered: September 2005

Member

Hi All,

Thank you all, for the support given. Finally i sort out the problem. Problem was the job_queue_processes.

Once again Thank You very much.

Report message to a moderator

Previous Topic:	help internal oracle
Next Topic:	sun cluster failover repetedely

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 26 13:24:15 CST 2025