Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: dbms_job - need help

Re: dbms_job - need help

From: Jeff Smith <spamnadajsmith_at_provide.net>
Date: Mon, 19 Jul 1999 11:54:33 -0400
Message-ID: <37934A39.8C60C852@provide.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US