Home » RDBMS Server » Server Administration » DBMS_SCHEDULER - External Destination Jobs (Oracle 19)
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
Previous Topic: ORA 03137
Next Topic: Other way to get the Schema Size other than dba_segments view
Goto Forum:
  


Current Time: Thu Feb 22 14:18:03 CST 2024