Re: Scheduling jobs

>Have you setup the scheduler?
>
>Check your init.ora params
>
>job_queue_processes
>job_queue_interval
>

Yes, the above two lines have to be set up. However, i think you may already have them otherwise you wouldn't know about the broken jobs.

The only other thing I can think of is whether the user who is submitting and running the job has EXPLICIT privileges to alter indexes (e.g grant the alter index priv directly to that user as opposed to granting it to them via a role). Packages such as dbms_job and dbms_sql know nothing about roles, hence the direct priv allocation to the user.

Also, in dbms_job, it may help to commit after the command which runs the procedure.
Good Luck.

Mark

(ps 15 mins for rebuilding indexes?? Phew!)

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!