Re: dbms_job on Oracle 8.1.6

In article <7X5F5.29393$uq5.595889_at_news6-win.server.ntlworld.com>,   "Jeremy Smith" <jeremy.d.smith_at_bigfoot.com> wrote:
> I am having a brain lock :( what am I doing wrong??
>
> I am submitting a job to the job queue and it is just sitting there. I
> submit it with a start time of sysdate and next run of 5/1440 (5
 mins) but
> it never runs. Have I forgotten to do something?? What can I check
>
> Jez
>
>

Query USER_JOBS:

select job, what, last_date, last_sec, this_date, this_sec, next_date,next_sec
from user_jobs;

You should see last_date, last_sec, next_date and next_sec populated with the proper values. (Upon successful submission you should also have received a job number -- use that to query USER_JOBS).

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.