OraFAQ Forum: SQL & PL/SQL » Deleting a Job from dba

Home » SQL & PL/SQL » SQL & PL/SQL » Deleting a Job from dba_jobs table

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

Deleting a Job from dba_jobs table [message #150661]

Thu, 08 December 2005 23:49

jayasree
Messages: 5
Registered: December 2005
Location: Hyderabad

Junior Member

hi,

We have deleted a job from dba_jobs using the following command from the SQLprompt

SQL>exec dbms_job.remove(10);

But when I go and query the dba_jobs table from TOAD, I can still see that job in it.

Cud someone help us in this regd?

Thanks a lot in advance.

Rgds,

Jayasree.

Report message to a moderator

Re: Deleting a Job from dba_jobs table [message #150791 is a reply to message #150661]

Fri, 09 December 2005 14:22

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

Did you commit after removing the job? The removal is a transaction that you have to either commit or rollback.

Report message to a moderator

Previous Topic:	how to parallelize SQL processing
Next Topic:	Update a table with its own data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Aug 05 04:21:38 CDT 2025