dbms_job - need help

I'm trying to get dbms_job to work, but it ain't working. First I checked v$parameter:

job_queue_interval - 60
job_queue_processes - 1

Then I created my job with dbms_job.isubmit and then called dbms_job.run to make sure it worked and the interval was working the way I wanted it.  The results:

Job: 1
What: search_cleanup;
Interval: sysdate + (1/192)
Last Date: 14-JUL-99 08:50:35
Next Date: 14-JUL-99 08:58:05

Now it's 14-JUL-99 09:12:52 and the job still has not executed. What am I missing? Is there any way to check and make sure SNP actually woke up and did anything?

Thanks

-Mike

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jul 14 1999 - 08:25:02 CDT