-
dbms_job.submit questions
let's say if I have two jobs schedule at 7:00pm and 8:00pm to be run every night. If the database was shutdown from 5:00pm to 8:30pm, from 8:30pm , will Oracle still run the job at 7:00pm or 8:00pm , or it won't run again till tomorrow.
-
It would be the second case.
Sam
Thanx
Sam
Life is a journey, not a destination!
-
that's what I thought, the job should start till tomorrow but I got this error on my log and I am bit confused here:
ARC0: Beginning to archive log# 6 seq# 4224
ARC0: Completed archiving log# 6 seq# 4224
Sun Jul 20 20:41:25 2003
Thread 1 advanced to log sequence 4226
Current log# 2 seq# 4226 mem# 0: C:\ORADATA\prod\LOG2prod_A.RDO
Current log# 2 seq# 4226 mem# 1: C:\ORADATA\prod\LOG2prod_B.RDO
Sun Jul 20 20:19:25 2003
ARC0: Beginning to archive log# 1 seq# 4225
ARC0: Completed archiving log# 1 seq# 4225
Sun Jul 20 20:41:06 2003
Error 2068 trapped in 2PC on transaction 3.4.27367. Cleaning up.
Error stack returned to user:
ORA-02050: transaction 3.4.27367 rolled back, some remote DBs may be in-doubt
ORA-02068: following severe error from ELM
ORA-03113: end-of-file on communication channel
Sun Jul 20 20:41:06 2003
DISTRIB TRAN prod.WORLD.a3499301.3.4.27367
is local tran 3.4.27367 (hex=03.04.6ae7)
insert pending collecting tran, scn=5848393606109 (hex=551.af6c63dd)
Sun Jul 20 20:41:06 2003
Errors in file C:\ORACLE\ADMIN\prod\BDUMP\prodRECO.TRC:
ORA-12560: TNSrotocol adapter error
Sun Jul 20 20:41:06 2003
Errors in file C:\ORACLE\ADMIN\prod\BDUMP\prodRECO.TRC:
ORA-12560: TNSrotocol adapter error
Sun Jul 20 20:41:06 2003
Errors in file C:\ORACLE\ADMIN\prod\BDUMP\prodRECO.TRC:
ORA-12560: TNSrotocol adapter error
my database is down from 5:00pm to 8:30pm, at 8:41 look like there is a job running and I don't have anything to run at this time, only two jobs at 7:00pm, 8:00pm
-
Originally posted by sambavan
It would be the second case.
No, it would not be the second case.
At 8:30pm (or very soon thereafter, depending on your JOB_QUEUE_INTERVAL parameter), when the database is bringed up again, both jobs that were scheduled to run at 7:00pm and 8:00pm will be started and will be run simultaneously (provided your JOB_QUEUE_PROCESSES allows it to run more than one dbms job simultaneously).
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Jurij,
Thanx for the correction. Afternoon lunch doesn't seems to allow me to think well, OH my bad!!! :(
Sam
Thanx
Sam
Life is a journey, not a destination!
-
job_queue_processes=4
job_queue_interval=60
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|