OraFAQ Forum: Server Administration » DBMS_SCHEDULER

Home » RDBMS Server » Server Administration » DBMS_SCHEDULER - External Destination Jobs (Oracle 19)

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

DBMS_SCHEDULER - External Destination Jobs [message #689374]

Fri, 01 December 2023 13:00

agsrivaths
Messages: 1
Registered: December 2023

Junior Member

Hello,

I am looking for some help with DBMS SCHEDULER in Oracle. We have multiple remote servers registered with our Oracle databases(with Oracle scheduler agents). And we schedule our jobs in these remote servers (Oracle client alone installed) as external jobs.

Typically our ALL_SCHEDULER_EXTERNAL_DESTS looks like below.

OWNER|DESTINATION_NAME|HOSTNAME      |PORT|IP_ADDRESS   |ENABLED|
-----+----------------+--------------+----+-------------+-------+
SYS  |SERVER1         |xxxxxxxxxxxx  |xxxx|x.x.x.x      |TRUE   |
SYS  |SERVER2         |xxxxxxxxxxxx  |xxxx|x.x.x.x      |TRUE   |
SYS  |SERVER3         |xxxxxxxxxxxx  |xxxx|x.x.x.x      |TRUE   |
SYS  |SERVER4         |xxxxxxxxxxxx  |xxxx|x.x.x.x      |TRUE   |
SYS  |SERVER5         |xxxxxxxxxxxx  |xxxx|x.x.x.x      |TRUE   |

I would like to know if we have any means to control the number of jobs submitted in each of these registered external servers with help of DBMS_SCHEDULER ? Say for example, SERVER1 max of 60 jobs, SERVER2 max of 30 jobs and so forth...

Thanks in advance.

Regards

Report message to a moderator

Previous Topic:	ORA 03137
Next Topic:	Other way to get the Schema Size other than dba_segments view

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 27 04:33:49 CDT 2024