Re: DBMS_JOB simple question (I think ...)

Hello to you all,

I already found the problem. It was related to the procedure to be executed by the job. It's now corrected and everything is working fine.

Just for the records, my JOB_QUEUE_PROCESS parameter has the value 10.

Thank you all for your help and suggestions.

All the best,

Ricardo.

On 11/26/07, Luis Fernando Cerri <lfcerri_at_gmail.com> wrote:
>
> Hello, Santos.
>
> Is your JOB_QUEUE_PROCESS greater than 0?
>
> After the time that the job was supposed to run, what do the columns
> THIS_TIME, LAST_TIME and FAILURES show?
>
> Is column FAILURES being incremented? If yes, then your job is
> running, but with error. Check your background_dump_dest for traces.
>
> If column LAST_TIME was updated and FAILURES is still zero, check if
> your procedure really does what you expect it to do and the way you
> are checking it run is correct.
>
> Cerri
>
>
>
> 2007/11/26, Ricardo Santos <saints.richard_at_gmail.com>:
> >
> > Hello to you all,
> >
> > Sorry for such a dummy question, but sometimes the simplest things can
> be
> > the hard ones.
> >
> > I just want to submit a job to the database to be executed only once at
> a
> > certain time in future. This job will execute a stored procedure.
> >
> > This is how I'm doing it:
> >
> >
> >
> > DECLARE
> >
> > X NUMBER;
> >
> >
> >
> > BEGIN
> >
> > SYS.DBMS_JOB.SUBMIT
> >
> > ( job => X
> >
> > ,what => 'NECI_UIAPP_DBO.DUMMY_PROCEDURE;'
> >
> > ,next_date => to_date('26-11-2007 17:00:00','dd/mm/yyyy
> hh24:mi:ss')
> >
> > ,no_parse => FALSE
> >
> > );
> >
> >
> >
> > COMMIT;
> >
> > END;
> >
> >
> >
> > I think the user that is submitting the job has the correct grants. It
> has
> > the CREATE JOB and the EXECUTE grant on DBMS_JOB.
> >
> >
> >
> > I don't understand why but my database is not executing the job. Can
> someone
> > give me an help on this ?
> >
> >
> >
> >
> >
> > Thank you all your attention.
> >
> >
> >
> > Best Regards,
> >
> > Ricardo Santos
> >
> >
>

--
http://www.freelists.org/webpage/oracle-l