OraFAQ Forum: Server Administration » change attributes by dbms

Home » RDBMS Server » Server Administration » change attributes by dbms_scheduler (10.2.0.2)

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

change attributes by dbms_scheduler [message #494533]

Tue, 15 February 2011 10:57

varunvir
Messages: 389
Registered: November 2007

Senior Member

Hi Experts,
I am going to change time interval for a job
with the help of DBMS_SCHEDULER.SET_ATTRIBUTE.
I have some basic questions:-
How would I know that previous job was created with
the dbms_jobs or dbms_scheduler package.
If it was created with dbms_jobs package,would i be
able to change time intervals with above command using
dbms_scheduler.

Thanks,
Varun Punj,

[Updated on: Tue, 15 February 2011 11:02] by Moderator

Report message to a moderator

Re: change attributes by dbms_scheduler [message #494535 is a reply to message #494533]

Tue, 15 February 2011 11:03

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

dbms_job -> DBA_JOBS
dbms_scheduler -> DBA_SCHEDULER_JOBS

Quote:

If it was created with dbms_jobs package,would i be
able to change time intervals with above command using
dbms_scheduler.

No, use DBMS_JOB.INTERVAL

Regards
Michel

Report message to a moderator

Re: change attributes by dbms_scheduler [message #494536 is a reply to message #494533]

Tue, 15 February 2011 11:06

cookiemonster
Messages: 13922
Registered: September 2008
Location: Rainy Manchester

Senior Member

dbms_job and dbms_scheduler and completely independant. They use different views to see what they are running.
You can not use one to modify the other.
I suggest you read the documentation on both.

Report message to a moderator

Re: change attributes by dbms_scheduler [message #494556 is a reply to message #494533]

Tue, 15 February 2011 12:51

varunvir
Messages: 389
Registered: November 2007

Senior Member

Thanks Michel and cookiemonster.

Report message to a moderator

Previous Topic:	Oracle Trace
Next Topic:	upgrading from 9.2.0.7 to 11.1.0 (2 Merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 08 09:39:40 CDT 2024