Re: Job never start based on schedule

Resant wrote:
>
> Sorry, I'am still newbie in Oracle, so could you explain more detail
> about how to show parameter job_queue_processes and where should I
> issue the alter system set job_queue_processes scope=memory|spfile|both
> .
> Or maybe if you don't mind, could you give some link that should I
> look.
>
> Thanks a lot
>
> Resant

some examples...

select * from v$parameter where name = 'job_queue_processes'; select * from v$spparameter where name = 'job_queue_processes';

alter system set job_queue_processes = 16 scope=spfile; alter system set job_queue_processes = 16 scope=both;

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------