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

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