Re: ORA-06512 when I put JOB_DBMS.INTERVAL

From: <mtn_bikers_at_msn.com>
Date: 27 Mar 2006 08:05:45 -0800
Message-ID: <1143475545.904580.136090@v46g2000cwv.googlegroups.com>

Thanks Sybrand,

I put this command and it works. I confused with single quote and double quote.

---

exec DBMS_JOB.INTERVAL(1,'next_day(sysdate,''WEDNESDAY'')')

---

Now, how can we check the next execution of a job (JOB #1 for exemple) to ensure the next execution?

Thanks. Received on Mon Mar 27 2006 - 10:05:45 CST