Re: dbms_job - need help

In article <7mi337$gtl$1_at_nnrp1.deja.com>, mtirving_at_my-deja.com writes
>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?
>

You could check to see whether the job is broken (probably not, as the next_date would have been changed to the year 4000) or has failures and whether anything is already running on the job queue: select * from dba_jobs_running;

Andy
--
Andy Hardy. PGP key available on request