Home » RDBMS Server » Performance Tuning » job not visible in dba_jobs
job not visible in dba_jobs [message #168605] Fri, 21 April 2006 02:32 Go to next message
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 #168755 is a reply to message #168605] Sat, 22 April 2006 02:12 Go to previous messageGo to next message
kmsalih
Messages: 197
Registered: March 2006
Senior Member
Can you please post the pl/sql block for the job.

rgds
SALIH KM
Re: job not visible in dba_jobs [message #169532 is a reply to message #168605] Thu, 27 April 2006 08:26 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
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;
Previous Topic: Bitmap or Normal Index
Next Topic: Tuning This Query
Goto Forum:
  


Current Time: Wed May 22 19:47:21 CDT 2024