dbms_job.submit questions
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: dbms_job.submit questions

  1. #1
    Join Date
    Sep 2002
    Posts
    411

    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.

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    It would be the second case.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Sep 2002
    Posts
    411
    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

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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?

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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!


  6. #6
    Join Date
    Sep 2002
    Posts
    411
    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
  •  



Click Here to Expand Forum to Full Width