Home » SQL & PL/SQL » SQL & PL/SQL » Scheduled jobs not Running as per schedule (Oracle 9.1)
Scheduled jobs not Running as per schedule [message #278494] Sun, 04 November 2007 14:14 Go to next message
balamurugan.murthy
Messages: 21
Registered: October 2007
Junior Member
I have sscheduled some jobs in my Oracle9.1 DB in GMT. The DB and session timezones are in GMT .I have checked the same using the following queries:

select systimestamp from dual

select current_timestamp from dual

select DBtimezone from dual

select sessiontimezone from dual

All the above shows the timezones in GMT.

But when i shedule the jobs in GMT its not getting invoked as per the schedule.

Could any one please help me in this issue ??

Thanks,
Bala.

Re: Scheduled jobs not Running as per schedule [message #278499 is a reply to message #278494] Sun, 04 November 2007 14:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post what did you do to know it is not schedule at the correct time.
Post all information relative to the jobs (query from dba_jobs).

Regards
Michel
Re: Scheduled jobs not Running as per schedule [message #278501 is a reply to message #278499] Sun, 04 November 2007 14:42 Go to previous messageGo to next message
balamurugan.murthy
Messages: 21
Registered: October 2007
Junior Member
JOB,LOG_USER,PRIV_USER,SCHEMA_USER,LAST_DATE,LAST_SEC,THIS_DATE,THIS_SEC,NEXT_DATE,NEXT_SEC,TOTAL_TIME,BROKEN,INTERVAL,FAILURES,WHAT, NLS_ENV,MISC_ENV,INSTANCE


244.00,ADMIN,ADMIN,SPSADMIN,,,,,11/04/2007 20:09:23,20:09:23,0.00,N,SYSDATE+1/1440,,clear_locks;,"NLS_LANGUAGE='ENGLISH' NLS_TERRITORY='UNITED KINGDOM' NLS_CURRENCY='' NLS_ISO_CURRENCY='UNITED KINGDOM' NLS_NUMERIC_CHARACTERS='.,' NLS_DATE_FORMAT='DD-MON-RR' NLS_DATE_LANGUAGE='ENGLISH' NLS_SORT='BINARY'",0102000200000000,0.00

dba_jobs entry above. job_queue_process =25. sorry for the poor formatting.
Re: Scheduled jobs not Running as per schedule [message #278502 is a reply to message #278494] Sun, 04 November 2007 14:44 Go to previous messageGo to next message
balamurugan.murthy
Messages: 21
Registered: October 2007
Junior Member
the job did not run at the scheduled time and the next date was not updated as well.
Re: Scheduled jobs not Running as per schedule [message #278503 is a reply to message #278501] Sun, 04 November 2007 14:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ok, this is unreadable.
Post the value of each column in front of its name.

Regards
Michel
Re: Scheduled jobs not Running as per schedule [message #278506 is a reply to message #278494] Sun, 04 November 2007 14:59 Go to previous messageGo to next message
balamurugan.murthy
Messages: 21
Registered: October 2007
Junior Member
JOB --------------------- 244

LOG_USER ---------- ADM

PRIV_USER ---------- ADM

SCHEMA_USER
LAST_DATE
LAST_SEC
THIS_DATE
THIS_SEC

NEXT_DATE -------- 11/04/2007 20:09:23

NEXT_SEC ------------ 20:09:23

TOTAL_TIME ---------- 0

BROKEN --- N

INTERVAL ---------------- SYSDATE+1/1440

FAILURES
WHAT ------------- clear_locks;

NLS_ENV ------ NLS_LANGUAGE='ENGLISH' NLS_TERRITORY='UNITED KINGDOM' NLS_CURRENCY='' NLS_ISO_CURRENCY='UNITED KINGDOM' NLS_NUMERIC_CHARACTERS='.,' NLS_DATE_FORMAT='DD-MON-RR' NLS_DATE_LANGUAGE='ENGLISH' NLS_SORT='BINARY'


MISC_ENV -------- 0102000200000000

INSTANCE -------- 0
Re: Scheduled jobs not Running as per schedule [message #278543 is a reply to message #278506] Mon, 05 November 2007 00:53 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Does job_queue_processess > 0?
Did you commit after submitting the job?

Regards
Michel
Previous Topic: Constraints over multiple rows?
Next Topic: adding column in the middle
Goto Forum:
  


Current Time: Tue Dec 06 00:00:52 CST 2016

Total time taken to generate the page: 0.13283 seconds