Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: my jobs from dbms_job don't run
"Sławomir Marcinkowski" wrote:
>
> I've submitted job, but it was never executed by database 8i EE on Tru64.
> Does anybody know why? What do I do wrong?
> Slawek
>
> JOB
> ----------
> 1
>
> LOG_USER
> ------------------------------
> ARTICLES
>
> PRIV_USER
> ------------------------------
> ARTICLES
>
> SCHEMA_USER
> ------------------------------
> ARTICLES
>
> LAST_DATE
> --------
> 01/12/05
>
> LAST_SEC
> --------
> 09:35:48
>
> THIS_DATE
> --------
>
> THIS_SEC
> --------
>
> NEXT_DATE
> --------
> 01/12/05
>
> NEXT_SEC
> --------
> 09:36:48
>
> TOTAL_TIME
> ----------
> 23
>
> BROKEN
> ------
> N
>
> FAILURES
> ----------------------------------------------------------------------------
> ------------------ ----------
> sysdate + 1/24/60
>
> INTERVAL
> ---------
> 0
>
> WHAT
> -----------------------------------------------------
> DBMS_MVIEW.REFRESH('articles.art_by_time_desc','cf');
>
> NLS_ENV
> ----------------------------------------------------------------------------
> ------------------
> NLS_LANGUAGE='POLISH' NLS_TERRITORY='POLAND' NLS_CURRENCY='zł'
> NLS_ISO_CURRENCY='POLAND'
> NLS_NUMERIC_CHARACTERS=', ' NLS_DATE_FORMAT='RR/MM/DD'
> NLS_DATE_LANGUAGE='POLISH'
> NLS_SORT='POLISH'
>
> MISC_ENV
> ----------
> 0102000200000000
>
> INSTANCE
> ----------------------------------------------------------------
> 0
Did you set the job_* parameters in your init.ora?
-- Ron Reidy Oracle DBA Reidy Consulting, L.L.C.Received on Wed Dec 05 2001 - 06:46:20 CST