Home » RDBMS Server » Server Administration » Objecttype ' JOB' (merged)
Objecttype ' JOB' (merged) [message #387036] Tue, 17 February 2009 12:23 Go to next message
prashanthgs
Messages: 89
Registered: May 2005
Location: chennai
Member
Hi,

a. I need to drop a object which the object type is "JOB". How I can do that.

b. If I do the complete schema export backup, will the objecttype "JOB" also got exported. Can we import that again with export dump after dropping it.

Thanks
OBJECT TYPE 'JOB' [message #387038 is a reply to message #387036] Tue, 17 February 2009 12:32 Go to previous messageGo to next message
prashanthgs
Messages: 89
Registered: May 2005
Location: chennai
Member
Hi,

a. How we can drop a object which the objectype ='JOB'

b. If we do the complete schema export backup, will objecttype 'JOB' be part of that dump (any specific parametes to be mentioned) and can we import the object back while importing after dropping the objects.

How it would be done.

Thanks



Re: Objecttype ' JOB' (merged) [message #387039 is a reply to message #387036] Tue, 17 February 2009 12:36 Go to previous message
Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
a. Use dbms_scheduler
b. Try it

Regards
Michel

[Updated on: Tue, 17 February 2009 12:42]

Report message to a moderator

Previous Topic: Table Space
Next Topic: need help in 10g database
Goto Forum:
  


Current Time: Fri Jul 05 18:52:14 CDT 2024