Search
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
Test DML-DDL performance
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Sybase » Test DML-DDL performance
Name: Test DML-DDL performance Platform: Sybase Category: Performance Description: Runs performance test on database.The procedure executes SELECT, INSERT, UPDATE and DELETE statements on dbwatch engine schema test…