Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Job never start based on schedule
job_queue_processes is an init.ora parameter.
You can verify the current setting by
show parameter job_queue_processes
You should also check whether you are using a server parameter file
(abbreviated spfile)
by issuing
show parameter spfile
(from the name of the init.ora it looks like you are using a spfile)
If that returns a file name you are using a spfile instead of init.ora
You should issue
alter system set job_queue_processes scope=memory|spfile|both
to change it.
For backup purposes you could
create pfile='<filename>' from spfile
Further info in the docs.
Hth
-- Sybrand Bakker Senior Oracle DBAReceived on Tue May 30 2006 - 03:03:24 CDT