OraFAQ Forum: Performance Tuning » job not visible in dba

Home » RDBMS Server » Performance Tuning » job not visible in dba_jobs

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: job not visible in dba_jobs [message #168755 is a reply to message #168605]

Sat, 22 April 2006 02:12

kmsalih
Messages: 197
Registered: March 2006

Senior Member

Can you please post the pl/sql block for the job.

rgds
SALIH KM

Report message to a moderator

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

Report message to a moderator

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?

Report message to a moderator

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;

Report message to a moderator

Previous Topic:	Bitmap or Normal Index
Next Topic:	Tuning This Query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 05:37:55 CDT 2025