Make sure the listener process for DMBS_JOB is installed and running on
the server.
mtirving_at_my-deja.com wrote:
>
> 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 Mon Jul 19 1999 - 10:54:33 CDT
