dbWatch AS

Search

The topic you requested could not be found.
Related topics are listed below.

No-engine jobs

Using Control Center » Monitoring » Job concepts » Job types » No-engine jobs

No-engine jobs No-engine jobs consists of a series of steps (defined in xml files), and each step retreives data and/or performs some computation on the data. The last step will also set a status and a text describing the current state of the job. The steps can be a…

No-engine jobs

Customization » Monitoring » No-engine jobs

No-engine jobs No-engine jobs are monitoring jobs that does not run in the database engine. No-engine jobs are jobs that run on the dbWatch Server, and typically run a SQL statement and process the result of this statement in javascript. Example code for different…

Engine jobs

Using Control Center » Monitoring » Job concepts » Job types » Engine jobs

Engine jobs Each engine Job consists of a set of objects (procedures, tables, etc) that are installed on the monitored database instance. The main procedure will be triggered by the dbWatch Server, This procedure will then perform a check or collect statistics…

Monitoring Engine

Using Control Center » Instance management » Instance Configuration » Monitoring Engine

The monitoring section of the Configure Instance view looks different depending on if you have a monitoring engine (i.e a database) defined on the instance. With engine: Without engine: Text may vary a bit depending on the database type. Button…

dbWatch engine alert

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » dbWatch engine alert

Name: dbWatch engine alert Platform: Sqlserver Category: Internal Internal Description: This procedure gathers statistics per database. Long description: This alert returns warning/alarm if there are several…

dbWatch engine alert

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » dbWatch engine alert

Name: dbWatch engine alert Platform: Postgres Category: Internal Description: Collects database uptime statistics. Long description: Version: 1 Default schedule: 15m Requires…

Engine CPU monitor

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Sybase » Engine CPU monitor

Name: Engine CPU monitor Platform: Sybase Category: Performance Description: Collects counter values for busy io and busy cpu, and are based on the dbWatch tasks ‘System monitor collector’ which runs the…

Example engine jobs

Customization » Monitoring » Editor for engine jobs » Example engine jobs

Example jobs To simplify development efforts for customers we provide example jobs with comments that should help development efforts. To use, right-click on the link and save as. Make sure its an xml file, with the name you want. You can edit it as its xml to change…

Editor for engine jobs

Customization » Monitoring » Editor for engine jobs

How to get here Example jobs We have some example jobs to make the development easier here. Edit Existing To edit an existing Task or Alert open the Task/Alert Editor by right clicking on any task or alert and select Edit task from the popup menu. Create new…

Report

Using Control Center » Monitoring » Job concepts » Report

Each job has a job report that is generated when you use the job menu and choose “Details”. The job report, here an example from the CPU load details on Oracle, provides a set of graphs, pie charts, and tables. It uses previously generated history…

Monitoring

Customization » Monitoring

Custom monitoring and editing monitoring jobs dbWatch has two types of monitoring jobs that can detect issues in the database instances. They are referred to as Engine jobs and “No-engine jobs”. Engine jobs are jobs that run inside the database engine,…

Job types

Using Control Center » Monitoring » Job concepts » Job types

There are currently two types of jobs, engine jobs, and no-engine jobs. The main difference between them is where processing occurs. Engine jobs do the processing in the database instance engine, and no-engine jobs do the processing on the Control Center Instance…

Job concepts

Using Control Center » Monitoring » Job concepts

This section will try to explain more in-depth some of the concepts used in monitoring jobs in Control Center. There are currently two types of jobs, engine jobs, and no-engine jobs. The main difference between them is where processing occurs. Engine jobs do the…

Parameters

Using Control Center » Monitoring » Job concepts » Parameters

Most of the monitoring jobs will have parameters. This is used controllable thresholds to adjust the monitoring job behavior and to better align it with the database instance and the preferences of the DBA. This is an example from the “Agent jobs check”…

Analyze tables

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Analyze tables

Name: Analyze tables Platform: Postgres Category: Maintenance Description: dbWatch engine framework job (for internal use only). Used for patching or upgrading of dbWatch engine framework. Long description: This…

Properties on Instances

Advanced Topics » FDL – Farm Data Language » Available properties » Properties on Instances

Instances are available under server through the instance property server/instance All instances have the following properties: Name Description Return type Typical values Extra name The given name of the instance String…

Versioning

Using Control Center » Monitoring » Job concepts » Versioning

All jobs and most resource files in Control Center have a version to differentiate between new and old jobs. It is used to upgrade jobs, and most jobs are auto-upgraded. Engine jobs have upgrade scripts built in, to alter tables and update changes to PL/SQL or TSQL…

Property System

Customization » Property System

There are several types of properties in dbWatch. Predefined properties Predefined properties are always present. For example, instances have properties called name and host. For more details see available properties Metadata properties Metadata properties are…

Bulk installing instances

Using Control Center » Instance management » Bulk installing instances

CSV File Format You can add instances in bulk. The prerequisite is to have a CSV file with the following…

Replica state

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Replica state

Name: Replica state Platform: Mysql Category: Cluster and Replication Description: This job checks if replica changes occurs. For example, if an instance becomes a replica or if an instance is no longer a…

Replica state

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Replica state

Name: Replica state Platform: Mariadb Category: Cluster and Replication Description: This job checks if replica changes occurs. For example, if an instance becomes a replica or if an instance is no longer a…

Customization

Customization

dbWatch Control Center is designed to be customizable and much of the contents are developed inside the product In this section, we will go over how you can customize different parts of the product. To proceed, click on of the topics below: Customize dbWatch Views…

Database status (noschema)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database status (noschema)

Name: Database status Platform: Sqlserver Category: Availability Description: This alert checks if the instance has been restarted since the last check Long description: Version: 2 Default…

MySQL max connections

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » MySQL max connections

Name: MySQL max connections Platform: Mysql Category: Description: Checking if the system is near maximum connections Long description: Version: 1 Default…

MySQL mysqld process

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » MySQL mysqld process

Name: MySQL mysqld process Platform: Mysql Category: Description: Checking if mysqld process is running Long description: Version: 1 Default schedule: 15m Requires engine…

Restore uptodate status

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Restore uptodate status

Name: Restore uptodate status Platform: Oracle Category: Internal Description: Checking if database restore is uptodate Long description: Version: 1.1 Default…

Extent fragmentation

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Extent fragmentation

Name: Extent fragmentation Platform: Oracle Category: Capacity Description: Checking for extent fragmentation in dba_free_space Long description: Version: 1.23 Default…

Max processes (noschema)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Max processes (noschema)

Name: Max processes Platform: Oracle Category: Capacity Description: Checking if database reaches max processes (processes) parameter Long description: Version: 1.0 Default…

Tablespace free space (noschema)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Tablespace free space (noschema)

Name: Tablespace free space Platform: Oracle Category: Capacity Description: Checking tablespaces for free space Long description: Version: 1.5 Default schedule: 2h Requires…

Aborted connects alert

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Aborted connects alert

Name: Aborted connects alert Platform: Mariadb Category: Availability Description: Checking if there is many aborted connects Long description: Version: 1 Default…

Maximum connections alert

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Maximum connections alert

Name: Maximum connections alert Platform: Mariadb Category: Availability Description: Checking if the system is near maximum connections Long description: Version: 1 Default…

MySQLd process alert

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » MySQLd process alert

Name: MySQLd process alert Platform: Mariadb Category: Availability Description: Checking if mysqld process is running Long description: Version: 1 Default…

Innodb cluster status

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Innodb cluster status

Name: Innodb cluster status Platform: Mysql Category: Cluster and Replication Description: This job checks state of all members in Innodb cluster Long description: Version: 1.2 Default…

Innodb cluster switch

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Innodb cluster switch

Name: Innodb cluster switch Platform: Mysql Category: Cluster and Replication Description: This job checks if Innodb cluster PRIMARY/SECONDARY switch occurs. Long…

Dataguard apply time

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Dataguard apply time

Name: Dataguard apply time Platform: Oracle Category: Cluster and Replication Description: Checking apply time in dataguard standby nodes Long description: Version: 1.0 Default…

Dataguard archive sequence apply lag

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Dataguard archive sequence apply lag

Name: Dataguard archive sequence apply lag Platform: Oracle Category: Cluster and Replication Description: Checking lag of applied archive logs on dataguard standby node Long…

Dataguard startup time

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Dataguard startup time

Name: Dataguard startup time Platform: Oracle Category: Cluster and Replication Description: Checking startup time on dataguard standby nodes Long description: Version: 1.0 Default…

Dataguard transport time

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Dataguard transport time

Name: Dataguard transport time Platform: Oracle Category: Cluster and Replication Description: Checking transport time in dataguard standby nodes Long description: Version: 1.0 Default…

Data Guard role switch

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Data Guard role switch

Name: Data Guard role switch Platform: Oracle Category: Cluster and Replication Description: This job checks if Primary/Standby switch occurs. Long description: Version: 1.5 Default…

RMAN backup status (noschema)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » RMAN backup status (noschema)

Name: RMAN backup status Platform: Oracle Category: Availability Description: Checking status of the last RMAN backup Long description: Version: 1.0 Default…

ASM diskgroup space (noschema)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » ASM diskgroup space (noschema)

Name: ASM diskgroup space Platform: Oracle Category: Capacity Description: Checking available space on the ASM diskgroups Long description: Version: 1.1 Default…

Flash recovery space usage (noschema)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Flash recovery space usage (noschema)

Name: Flash recovery space usage Platform: Oracle Category: Capacity Description: Checking available space on the Flash recovery area Long description: Version: 1.0 Default…

Replication delay alert

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Replication delay alert

Name: Replication delay alert Platform: Postgres Category: Cluster Description: Checks for BDR replication lag Long description: Version: 1.01 Default schedule: 15m Requires…

MariaDB Index Redundancy Checker

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » MariaDB Index Redundancy Checker

Name: MariaDB Index Redundancy Checker Platform: Mariadb Category: Performance Description: Shows percentage of temporary tables written to disk Long description: Version: 1 Default…

MariaDB Space Optimizer

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » MariaDB Space Optimizer

Name: MariaDB Space Optimizer Platform: Mariadb Category: Availability Description: Tells the user how much space tables in a specific database consume. Long description: Version: 1 Default…

Database disk space usage

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database disk space usage

Name: Database disk space usage Platform: Sqlserver Category: Capacity Description: Checks free space on drives where all data and transaction log files are defined. Drives where no data files exist will be…

Replica count

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Replica count

Name: Replica count Platform: Mysql Category: Cluster and Replication Description: This job checks all of replicas currently registered with the source. Long…

SYS.AUD size

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » SYS.AUD size

Name: SYS.AUD size Platform: Oracle Category: Capacity Description: Checking if SYS.AUD$ fills up with data Long description: Version: 1.1 Default schedule: 3h Requires engine…

Vacuum alert

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Vacuum alert

Name: Vacuum alert Platform: Postgres Category: Capacity Description: Checks the size of the log file. Long description: This job hecks if vacuum has been performed…

Replication slave client alert

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Replication slave client alert

Name: Replication slave client alert Platform: Postgres Category: Cluster Description: Checks for BDR replication lag Long description: Version: 1 Default schedule: 15m Requires…

Replica count

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Replica count

Name: Replica count Platform: Mariadb Category: Cluster and Replication Description: This job checks all of replicas currently registered with the source. Long…

Replica delay

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Replica delay

Name: Replica delay Platform: Mysql Category: Cluster and Replication Description: This job checks how “late” the replica is, and measures the time difference in seconds between the replication SQL (applier) thread and…

Health state

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Health state

Name: Health state Platform: Sqlserver Category: Cluster and Replication Description: Checks groups health state. Long description: Version: 1.2 Default…

Replica states

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Replica states

Name: Replica states Platform: Sqlserver Category: Cluster and Replication Description: Checks role state for all alwayson groups. Long description: Version: 1.3 Default…

Replica delay

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Replica delay

Name: Replica delay Platform: Mariadb Category: Cluster and Replication Description: This job checks how “late” the replica is, and measures the time difference in seconds between the replication SQL (applier) thread…

Dataguard standby archivelog gap

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Dataguard standby archivelog gap

Name: Dataguard standby archivelog gap Platform: Oracle Category: Cluster and Replication Description: Checking for archivelog gap between threads on primary and standby instances in a replication/service group. Metadata…

Dataguard standby archivelog gap

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Dataguard standby archivelog gap

Name: Dataguard standby archivelog gap Platform: Oracle Category: Cluster and Replication Description: Checking for archivelog gap between threads on primary and standby instances in a replication/service group. Metadata…

Database backup (MS2000)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database backup (MS2000)

Name: Database backup (2000) Platform: Sqlserver Category: Availability Description: This procedure analyzed the backup statistics from msdb.dbo.backupset table (excluding system databases: master, model and…

Database backup (system dbs)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database backup (system dbs)

Name: Database backup (system dbs) Platform: Sqlserver Category: Availability Description: This procedure analyzed the system database backups statistics from msdb.dbo.backupset table. Long…

Missing database backup (noschema)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Missing database backup (noschema)

Name: Missing database backup Platform: Sqlserver Category: Availability Description: This alert checks if the instance has been restarted since the last check Long description: This job checks for each database…

Member state

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Member state

Name: Member state Platform: Sqlserver Category: Cluster and Replication Description: Checks the status of each member node of the current WSFC cluster based on Dynamic Management Views…

AlwaysOn database backup alert

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » AlwaysOn database backup alert

Name: AlwaysOn database backup alert Platform: Sqlserver Category: Cluster and Replication Description: Checks the status of each member node of the current WSFC cluster based on Dynamic Management Views…

dbWatch Server activity alert

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » dbWatch Server activity alert

Name: dbWatch Server activity alert Platform: Sqlserver Category: Internal Internal Description: This procedure gathers statistics per database. Long description: This alert returns warning/alarm if the dbWatch…

Blocking detector (noschema)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Blocking detector (noschema)

Name: Blocking detector Platform: Sqlserver Category: Performance Description: This task collects the size of memory objects that are currently allocated by the SQL Server Long description: Checks whether there…

Framework

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Framework

Name: Framework Platform: Oracle Category: Maintenance Maintenance Description: Engine framework is used when upgrading earlier versions of dbWatch. Ensures the dbWatch Engine and dbWatch Server run compatible…

Database backup (noschema)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database backup (noschema)

Name: Database backup Platform: Sqlserver Category: Availability Description: This alert checks if the instance has been restarted since the last check Long description: This job checks the backup statistics…

Database log backup (noschema)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database log backup (noschema)

Name: Database log backup Platform: Sqlserver Category: Availability Description: This alert checks if the instance has been restarted since the last check Long description: This job checks the transaction log…

Missing database log backup (noschema)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Missing database log backup (noschema)

Name: Missing database log backup Platform: Sqlserver Category: Availability Description: This alert checks if the instance has been restarted since the last check Long description: This job checks for each…

AlwaysOn transaction log backup alert

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » AlwaysOn transaction log backup alert

Name: AlwaysOn transaction log backup alert Platform: Sqlserver Category: Cluster and Replication Description: Checks the status of each member node of the current WSFC cluster based on Dynamic Management Views…

Database log backup

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database log backup

Name: Database Log backup Platform: Sqlserver Category: Availability Description: This procedure checks the database transaction log backups from the msdb.dbo.backupset table (excluding system databases: master, model and…

Framework

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Framework

Name: Framework Platform: Postgres Category: Maintenance Description: dbWatch engine framework job (for internal use only). Used for patching or upgrading of dbWatch engine framework. Long description: dbWatch…

Data file size check (noschema)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Data file size check (noschema)

Name: Data file size check Platform: Sqlserver Category: Capacity Description: This procedure collects space usage in all filegroups defined in each database. The undocumented ‘sp_MSforeachdb’ Stored Procedure…

Instance memory check (noschema)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Instance memory check (noschema)

Name: Instance memory check Platform: Sqlserver Category: Performance Description: This task collects the size of memory objects that are currently allocated by the SQL Server Long description: The alert checks…

Vacuum tables

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Vacuum tables

Name: Vaccum tables Platform: Postgres Category: Maintenance Description: This job runs VACUUM statement on every database and reclaims storage occupied by dead tuples. It’s necessary to do VACUUM periodically,…

Database disk capacity (noschema)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database disk capacity (noschema)

Name: Database disk capacity Platform: Sqlserver Category: Capacity Description: This procedure collects space usage in all filegroups defined in each database. The undocumented ‘sp_MSforeachdb’ Stored Procedure…

Disk space check (noschema)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Disk space check (noschema)

Name: Disk space check Platform: Sqlserver Category: Capacity Description: This procedure collects space usage in all filegroups defined in each database. The undocumented ‘sp_MSforeachdb’ Stored Procedure is…

Database backup

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database backup

Name: Database backup Platform: Sqlserver Category: Availability Description: This procedure analyzes the backup statistics (type D and I) from the msdb.dbo.backupset table (excluding the system databases: master, model and…

Database backup (SIMPLE)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database backup (SIMPLE)

Name: Database backup (SIMPLE) Platform: Sqlserver Category: Availability Description: This procedure analyzes the backup statistics (type D) from the msdb.dbo.backupset table for databases in SIMPLE recovery model…

Database backup (system databases)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database backup (system databases)

Name: Database backup (system databases) Platform: Sqlserver Category: Availability Description: This procedure analyzes the FULL backup statistics for the system databases (master, model and msdb) using data from the…

Password expire

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Password expire

Name: Password expire Platform: Oracle Category: Availability Description: Checks for users whose password will soon expire. Long description: Task checks for users whose password will soon…

Transaction log space usage (noschema)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Transaction log space usage (noschema)

Name: Transaction log space usage Platform: Sqlserver Category: Capacity Description: This procedure collects space usage in all filegroups defined in each database. The undocumented ‘sp_MSforeachdb’ Stored…

Cycle error log

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Cycle error log

Name: Cycle error log Platform: Sqlserver Category: Maintenance Description: This task cycle MS SQL Server error log and Agent error log files. Long description: By default, there are seven SQL Server error logs…

Framework (MS2000)

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Framework (MS2000)

Name: Framework Platform: Sqlserver Category: Maintenance Description: dbWatch engine framework task (for internal use only). Used for patching or upgrading of dbWatch engine framework. Long…

Database mount state

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Database mount state

Name: Database mount state Platform: Oracle Category: Availability Description: Checks the ‘soft limit’ and the ‘hard limit’ of the maximum number of physical OS files, that can be mapped to an…

Framework

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Framework

Name: Framework Platform: Sqlserver Category: Maintenance Description: dbWatch engine framework job (for internal use only). Used for patching or upgrading of dbWatch engine framework. Long…

Control Center Jobs

Using Control Center » Monitoring » Control Center Jobs

Jobs (older dbWatch versions Tasks and alerts) are the cornerstone of the dbWatch Monitoring module. Jobs perform the actual monitoring of the database instance. There are two types of Monitoring in dbWatch. The Basic and Standard monitoring. To see each monitoring…

Architecture

Product Overview » Architecture

Architecture components The dbWatch installation consists of three components: dbWatch Monitor/Client serves as the front-end GUI dbWatch Server is the core business logic and central hub of the system dbWatch Framework contains stored objects in the registered…

Maintenance

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Maintenance

Jobs in the Maintenance category Control Center Jobs Description Oracle Framework Engine framework is used when upgrading earlier versions of dbWatch. Ensures the dbWatch Engine and dbWatch Server run compatible…

Upgrade

Customization » Monitoring » Editor for engine jobs » Upgrade

When you add upgrade/implementation steps you get prompted for “Version”, and that is a comma-separated list of versions that this implementation can upgrade from. It is always to the current version. You can use the configuration parameters to create…

Datafile status

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Datafile status

Name: Datafile status Platform: Oracle Category: Availability Description: Checks the ‘soft limit’ and the ‘hard limit’ of the maximum number of physical OS files, that can be mapped to an Oracle…

Max datafiles

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Max datafiles

Name: Max datafiles Platform: Oracle Category: Availability Description: Checks the ‘soft limit’ and the ‘hard limit’ of the maximum number of physical OS files, that can be mapped to an Oracle…

Properties on Jobs

Advanced Topics » FDL – Farm Data Language » Available properties » Properties on Jobs

Jobs are available under instance through the task property server/instance[name = '...']/task The available properties are: Name Description Return type Typical values Extra name The name of the job String Blocking…

MySQL aborted connects

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » MySQL aborted connects

Name: Aborted connections Platform: Mysql Category: Availability Description: Checks the number of aborted client connections. Long description: Checks the number of aborted client connections. Usually this is…

Metadata

Customization » Monitoring » Editor for engine jobs » Metadata

Metadata is used to set metadata properties on the job once installed. Normally this is where the job grouping is set. ← Properties / Internal objects →

Internal objects

Customization » Monitoring » Editor for engine jobs » Internal objects

Internal objects are generated once you add objects in the implementation section. You can however adjust if the objects are dropped if the job installation fails, or stay present after any cleanup attempt. ← Metadata / External dependencies…

Installation variables

Customization » Monitoring » Editor for engine jobs » Installation variables

Installation variables are used if you want user input during job installation. It is mostly used for application-specific monitoring where the application schema or database can not be determined correctly by the job after installation and human input are…

Internal fragmentation check

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Internal fragmentation check

Name: Internal fragmentation check Platform: Sqlserver Category: Maintenance Description: Checks the internal fragmentation for tables and indexes in all databases. The information is extracted from the dynamic management…

DBMS uptime

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » DBMS uptime

Name: DBMS uptime Platform: Oracle Category: Availability Description: Collects uptime statistics in database. Long description: Task collects uptime statistics in…

External dependencies

Customization » Monitoring » Editor for engine jobs » External dependencies

External dependencies are used to add dependencies to external tables, views, functions, and procedures. External in this setting is external to, as not part of, this job. It can be external objects, such as tables and procedures that the procedures in this job…

Database link check

Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Database link check

Name: Database link check Platform: Oracle Category: Availability Description: Checks database links. Long description: In order to check private database links you have to create a following view ‘create…