| job not visible in dba_jobs [message #168605] |
Fri, 21 April 2006 02:32  |
chandanbhamra
Messages: 84
Registered: April 2005
Location: India
|
Member |
|
|
Hi
I have scheduled statspack.snap procedure after every two hours but when i query dba_jobs it shows me nothing. When i run report spreport.sql it shows me that snapshots are begin taken after every two hours.
what could be the reason that i not able to see the job in dba_jobs?
Thanks & Regards
Chandan Singh
|
|
|
|
|
|
| Re: job not visible in dba_jobs [message #169532 is a reply to message #168605] |
Thu, 27 April 2006 08:26  |
chandanbhamra
Messages: 84
Registered: April 2005
Location: India
|
Member |
|
|
What's wrong in this PL/SQL block. I want to run it in every 1 min but when i execute this script it shows jn = 65 but does not show anything in dba_jobs instead there is one more job going on with job no 1 when i try to remove that job using execute dbms_job.remove(1) it throws error
ORA-23421: job number 1 is not a job in the job queue.
Is there anything wrong i am doing in this?
declare
jn binary_integer;
begin
dbms_job.submit(jn,'statspack.snap;',SYSDATE,'SYSDATE+(1/(24*60))');
dbms_output.put_line('JN '||jn);
end;
Thanks & Regards
Chandan Singh
|
|
|
|
| Re: job not visible in dba_jobs [message #169565 is a reply to message #169532] |
Thu, 27 April 2006 10:31 |
kmsalih
Messages: 197
Registered: March 2006
|
Senior Member |
|
|
try this
show parameter job_queue_processes
There is no error in the pl/sql block.
In my db it is showing in the DBA_JOBS.
create a new job and check whether it is working or not?
|
|
|
|
| Re: job not visible in dba_jobs [message #170179 is a reply to message #169565] |
Tue, 02 May 2006 08:15 |
raji_kb02
Messages: 19
Registered: March 2006
|
Junior Member |
|
|
You have to issue commit after submiting the job. Then only it will be visible to all sessions.
declare
jn binary_integer;
begin
dbms_job.submit(jn,'statspack.snap;',SYSDATE,'SYSDATE+(1/(24*60))');
commit;
dbms_output.put_line('JN '||jn);
end;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
