dbms job error help!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: dbms job error help!

  1. #1
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262
    Hi Gurus,

    A dbms job failed on and the output from all_jobs is...


    JOB LOG_USER PRIV_USER
    --------- ------------------------------ ------------------------------
    SCHEMA_USER LAST_DATE LAST_SEC THIS_DATE THIS_SEC NEXT_DATE NEXT_SEC TOTAL_TIME B
    ------------------------------ --------- -------- --------- -------- --------- -------- ---------- -
    INTERVAL
    ----------------------------------------------------------------------------------------------------
    FAILURES
    ---------
    WHAT
    ----------------------------------------------------------------------------------------------------
    NLS_ENV
    ----------------------------------------------------------------------------------------------------
    MISC_ENV INSTANCE
    ---------------------------------------------------------------- ---------
    241 IRSPQT IRSPQT
    IRSPQT 08-JUL-02 17:49:54 10 Y
    NEXT_DAY(TRUNC(SYSDATE),'FRIDAY')+22
    16
    PQT_LES_UPLOAD;
    NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_CURRENCY='$' NLS_ISO_CURRENCY='AMERICA' NLS_NUME
    RIC_CHARACTERS='.,' NLS_DATE_FORMAT='DD-MON-YY' NLS_DATE_LANGUAGE='AMERICAN' NLS_SORT='BINARY'
    0102000200000000 0



    Any ideas???


    Thanks!


    Hemant

  2. #2
    Join Date
    Oct 2001
    Posts
    126
    Oracle can not successfully run your job for 16 attempts, so the job is marked as broken. I assume your code is working.

    Try
    'exec dbms_job.run(job#); '
    and see if you get any error msg on alter.log or trace file.

    Susan

  3. #3
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262
    Thanks Sue!
    Hemant

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