Jobs in the Cluster and replication category

Control Center Jobs Description
Oracle
Blocking detector for RAC Checks if a session is waiting on a TX (transaction) lock. (RAC only)
Memory session load for RAC Records the load memory of RAC active sessions over time.
MV Refresh Group Checks refresh date of scheduled jobs in refresh group(s).
Dataguard apply time Checking apply time in dataguard standby nodes
Dataguard archive sequence apply lag Checking lag of applied archive logs on dataguard standby node
Dataguard standby archivelog gap Checking for archivelog gap between threads on primary and standby instances in a replication/service group. Metadata “replicationgroup” must be set on all instances to the same as parameter replicationgroup. For upto 10 redo threads.
Dataguard startup time Checking startup time on dataguard standby nodes
Dataguard transport time Checking transport time in dataguard standby nodes
RAC instances status Reacts if one or more RAC instances are not available.
Session load Rac Records the number of active sessions over time (RAC only).
Snapshot Log(s) rows count Checks row count on all snapshot logs for given schema.
Snapshot Log(s) size Checks size of all snapshot logs.
Data Guard role switch This job checks if Primary/Standby switch occurs.
MS SQL Server
Database mirroring Checks state information of all mirrored databases.
Failover cluster host switch Checks if an instance switched to a differen host i a Windows Server Failover Cluster (WSFC).
Health state Checks groups health state.
Log shipping monitor Monitor the primary database in each log shipping configuration, including information about the last backup file and last restored file.
Log shipping monitor Monitor the secondary database in each log shipping configuration.
Member state Checks the status of each member node of the current WSFC cluster based on Dynamic Management Views sys.dm_hadr_cluster_members.
AlwaysOn database backup alert Checks the status of each member node of the current WSFC cluster based on Dynamic Management Views sys.dm_hadr_cluster_members.
AlwaysOn transaction log backup alert Checks the status of each member node of the current WSFC cluster based on Dynamic Management Views sys.dm_hadr_cluster_members.
Replica states Checks role state for all alwayson groups.
Replication status The following check provides general info in regards to any replication going on in a server.
Compliance optional
MS SQL Server patch status Checks latest updates for Microsoft SQL Server.
Consolidation (optional)
Database statistics This procedure gathers statistics per database.
PostgreSQL
BDR Replication lag Checks for BDR replication lag
Replication delay alert Checks for BDR replication lag
Replication slave client alert Checks for BDR replication lag
Replication slave client alert Checks for BDR replication lag
MySQL
NDB data memory usage check NDB data memory usage check
NDB data node status NDB data node status
Innodb cluster status This job checks state of all members in Innodb cluster
Innodb cluster switch This job checks if Innodb cluster PRIMARY/SECONDARY switch occurs.
Replica count This job checks all of replicas currently registered with the source.
Replica delay This job checks how “late” the replica is, and measures the time difference in seconds between the replication SQL (applier) thread and the replication I/O (receiver) thread.
Replica state This job checks if replica changes occurs. For example, if an instance becomes a replica or if an instance is no longer a replica.
MariaDB
NDB data memory usage check NDB data memory usage check
NDB data node status NDB data node status
Replica count This job checks all of replicas currently registered with the source.
Replica delay This job checks how “late” the replica is, and measures the time difference in seconds between the replication SQL (applier) thread and the replication I/O (receiver) thread.
Replica state This job checks if replica changes occurs. For example, if an instance becomes a replica or if an instance is no longer a replica.

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment