OraFAQ Forum: Server Administration » Re-scheduling DBA_SCHEDULER

Home » RDBMS Server » Server Administration » Re-scheduling DBA_SCHEDULER_JOBS to run on specific node? (Oracle10g , Linux)

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

Re-scheduling DBA_SCHEDULER_JOBS to run on specific node? [message #511930]

Thu, 16 June 2011 03:04

newbie01.oracle
Messages: 14
Registered: December 2009

Junior Member

Hi all,

Can someone please advise on how I can change the following jobs to run on a specific node instead of where it currently always run which is NODE1/INSTANCE1 of my 2-node cluster?

Am assuming it is INSTANCE_STICKINESS that I have to change but it seems like it only takes a TRUE or FALSE value? Perhaps someone knew of any Metalink Note that discusses this?

Any advise will be much appreciated. Thanks in advance.

1* select job_name, instance_stickiness from dba_scheduler_jobs
SQL> /

JOB_NAME INSTA
------------------------------ -----
AUTO_SPACE_ADVISOR_JOB TRUE
GATHER_STATS_JOB TRUE
FGR$AUTOPURGE_JOB TRUE
PURGE_LOG TRUE
MGMT_STATS_CONFIG_JOB TRUE
MGMT_CONFIG_JOB TRUE

6 rows selected.

SQL>

Report message to a moderator

Re: Re-scheduling DBA_SCHEDULER_JOBS to run on specific node? [message #511968 is a reply to message #511930]

Thu, 16 June 2011 06:05

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

Hi - you need to associate the job with a class, and set the service attribute for the class. Then start the service on the appropriate instance.
[update - typo]

[Updated on: Thu, 16 June 2011 06:06]

Report message to a moderator

Previous Topic:	Simple editing of initDB.ora
Next Topic:	Delete Statements useTemp Tablespace?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 27 01:38:00 CST 2025