Re: dbms_job - need help

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 19 Jul 1999 21:53:47 +0800
Message-ID: <37932DEB.612C@yahoo.com>

Jeff Smith wrote:
>
> 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.

Use submit not isubmit, and also ensure that you commit after submitting the job (they don't become active until you commit)...

--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Mon Jul 19 1999 - 08:53:47 CDT