-
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
-
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
-
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
|