Search
Related topics are listed below.
Availability
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Availability
Jobs in the Availability category Control Center Jobs Description Oracle Alert log check This check reads and looks for errors in the database alert log. Alert log check This check reads and looks for errors in the database…
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…
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…
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…
Jobs for PostgreSQL
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL
Control Center Jobs Description Availability Backup check – pg_dump Checks that there exists an up to date backup file. Backup check – WAL Checks that the WAL files have been backed up. DBMS…
Jobs for MySQL
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL
Control Center Jobs Description Availability DBMS uptime Collects uptime statistics in the database. MySQL aborted connects Checking if there is many aborted connects MySQL max connections Checking if the system…
Jobs for MariaDB
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB
Control Center Jobs Description Availability DBMS uptime Collects uptime statistics in the database. Aborted connects alert Collects uptime statistics in the database. Maximum connections alert Collects uptime…
Jobs for Sybase
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Sybase
Control Center Jobs Description Availability Database backup Checks backup status of all databases. Database status Checks status of all databases defined on the system. The following incidents triggers a warning or an…
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…
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…
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…
DBA jobs check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » DBA jobs check
Name: Dba Jobs check Platform: Oracle Category: Availability Description: Detecting failed scheduled jobs in old style dba_jobs. Long description: The BROKEN column in the Oracle dictionary view DBA_JOBS is used…
Agent Jobs Check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Agent Jobs Check
Name: Agent Jobs Check Platform: Sqlserver Category: Availability Description: Checks whether there exists jobs on the SQL server which have not been executed, or have failed during execution. Long description: …
Jobs for Oracle
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle
Control Center Jobs Description Availability Alert log check This check reads and looks for errors in the database alert log. Alert log check This check reads and looks for errors in the database alert log. Alert…
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…
Install jobs with CCC
Advanced Topics » Control Center Commandline » Install jobs with CCC
Prerequisites Before installing jobs through CCC you need to go through the steps described in Setting up a CCC node ← Set metadata with CCC / Get instance configuration with CCC →
Jobs grouped by category
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category
Jobs by category Jobs in Control Center are grouped by category to make it easier for users to locate the right monitoring job. The categories are: Availability Jobs that checks that the database and database related processes are functioning Capacity – Jobs…
Agent Jobs Check (MS2000)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Agent Jobs Check (MS2000)
Name: Agent Jobs Check (MS2000) Platform: Sqlserver Category: Availability Description: Checks whether there exists jobs on the SQL server which have not been executed or have failed during execution. Long…
Jobs grouped by platform
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform
Go to the individual platforms to see the jobs for that database platform Jobs for Oracle Jobs for MS SQLServer Jobs for MySQL Jobs for MariaDB Jobs for PostgreSQL Jobs for Sybase ← Control Center Jobs / Jobs for Oracle →
Jobs for MS SQL Server
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server
Control Center Jobs Description Availability Agent Jobs Check Checks whether there exists jobs on the SQL server which have not been executed, or have failed during execution. Agent Jobs Check for MS2000 Checks whether there…
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…
Database uptime
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Database uptime
Name: Database uptime Platform: Oracle Category: Availability Description: Collects database uptime statistics for all instances mounted on the database. Long description: Collects database uptime statistics for…
Job scheduling check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Job scheduling check
Name: Job scheduling check Platform: Oracle Category: Availability Description: Detecting failed scheduled jobs. The STATUS column in the Oracle dictionary view DBA_SCHEDULER_JOB_RUN_DETAILS is used to detect scheduled jobs…
Instance details
Using Control Center » Monitoring » Instance details
When navigating to an individual database instance, you get the instance details overview: This dashboard is intended to give an overview of what monitoring jobs are installed and how they are performing. The top tabs let you switch between the instance details…
Job templates
Customization » Monitoring » Job templates
Creating templates Template functionality makes it possible to automate installation and configuration of jobs across the entire database farm you are managing. The configuration interface is available in the menu Server -> Server Configuration -> Edit job…
Alert log check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Alert log check
Name: Alert log check Platform: Oracle Category: Availability Description: This check reads and looks for errors in the database alert log. Long description: This check reads and looks for errors in the database…
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…
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…
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”…
Unit4 Agresso
Advanced Topics » Application Modules » Unit4 Agresso
Installation guide for Microsoft SQL Server and Oracle platforms The dbWatch Agresso Module is based on the dbWatch Engine Framework and can be installed during the initial installation of the dbWatch Framework. If the MS SQL Server or Oracle instance where the…
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…
Installation of the Security and Compliance package
Installing and using premium packages » Security and Compliance package » Installation of the Security and Compliance package
Installation of the Security and Compliance package The Security and Compliance package is a premium package that comes with extra cost. If you want to get this package and its not part of your current license, please contact sales@dbwatch.com. To install the…
Properties
Customization » Monitoring » Editor for engine jobs » Properties
The properties section defines the main settings for the job. Once a job is created the “Task name”, “Company” and “Compatibility” is specified. “Task name” is the visible job name when you install a job or when its…
Automated maintenance package
Installing and using premium packages » Automated maintenance package
Automated Maintenance Package The Automated Maintenance Package is an additional package for dbWatch Control Center, designed to streamline routine database maintenance tasks. By automating essential upkeep, this package helps ensure optimal database performance and…
Security and Compliance package on SQL Server
Installing and using premium packages » Security and Compliance package » Security and Compliance package on SQL Server
The Security and Compliance package The Security and Compliance package provides a detailed evaluation of your Microsoft SQL Server’s security and compliance, managed via dbWatch Control Center. It offers in-depth insights into your server’s security and…
Consolidation
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Consolidation
Jobs in the Consolidation category Control Center Jobs Description MS SQL Server Optional Database statistics This procedure gathers statistics per database.
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…
Compliance
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Compliance
Jobs in the Compliance category Control Center Jobs Description MS SQL Server Optional MS SQL Server patch status Checks latest updates for Microsoft SQL Server.
Job menus
Using Control Center » Monitoring » Job menus
Each job has a set of menus. They can be accessed if you right-click on a job. This gives you several options. “Run now” will trigger the job now, outside of the normal schedule. “Details” will open the job report, providing details about…
SQL Server Agent
Using Control Center » Management » Management on SQL Server » SQL Server Agent
SQL Server agent allows you to check the status of the agent, look into agent jobs and its statistics, and create new agent jobs. ← Security / Operating System Manager →
Migration
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Migration
Jobs in the Migration category Control Center Jobs Description Oracle Optional Statistics migration Migrates statistics from a number of tasks from dbWatch version 12 to dbWatch CC. MS SQL…
Available properties
Advanced Topics » FDL – Farm Data Language » Available properties
Properties available on dbWatch Servers Properties on instances Properties available on jobs Properties available on internal ← orderby function / Properties on dbWatch Servers →
Adding a MySQL Instance
Using Control Center » Instance management » Adding a MySQL Instance
How to get here To open the “Add Instance Wizard”, click on the “Plus (+)” sign on the bottom left of the dbWatch Client. This will bring up the “Add Instance” wizard, which will guide you through the following steps. Select Instance Type and Input…
Job details
Using Control Center » Monitoring » Job details
When you click on one of the jobs in the job tree, you can see a more detailed job overview. The idea of this overview is to show current and historical state, configured parameters and how the job is behaving on other database instances. In the top left…
Adding a PostgreSQL Instance
Using Control Center » Instance management » Adding a PostgreSQL Instance
How to get here To open the “Add Instance Wizard”, click on the “Plus (+)” sign on the bottom left of the dbWatch Client. This will bring up the “Add Instance” wizard, which will guide you through the following steps. Select Instance Type and Input…
MV Refresh Group(s)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » MV Refresh Group(s)
Name: MV Refresh Group(s) Platform: Oracle Category: Cluster and Replication Description: Checks refresh date of scheduled jobs in refresh group(s). Long description: Task checks refresh date of all scheduled…
Release notes
About dbWatch Control Center » Release notes
dbWatch Control Center (2024-10-07) Download Improvements MS SQL Server – Job “Database disk capacity”. New parameter “combine thresholds”. This parameter allows you to combine the conditions of both the “alarm threshold…
Set metadata with CCC
Advanced Topics » Control Center Commandline » Set metadata with CCC
Prerequisites Before settings metadata through CCC you need to go through the steps described in Setting up a CCC node Metadata is defined in a file (default “metadata.properties”) ← Add instance with CCC / Install jobs with CCC…
Cleanup MSDB history tables
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Cleanup MSDB history tables
Name: Cleanup MSDB history tables Platform: Sqlserver Category: Maintenance Description: This task deletes entries in the MSDB database history tables which holds statistics of backup/restore, jobs and maintenance plan…
dbWatch alerts
Using Control Center » Management » Management on SQL Server » dbWatch alerts
dbWatch alerts is a list of monitoring jobs in the database in warning or alarm state for this database instance. Example: This is handy so you know you are working on the right database instance when you are correcting issues. You can interact with the…
Adding a SQLServer Instance
Using Control Center » Instance management » Adding a SQLServer Instance
How to get here To open the “Add Instance Wizard”, click on the “Plus (+)” sign on the bottom left of the dbWatch Client. Select Instance Type and Input Connection Details Specify the host and port number. dbWatch will attempt to…
Acknowledgement system
Using Control Center » Monitoring » Job concepts » Acknowledgement system
The acknowledgment system is designed to make sure that jobs that have had alarms in the past, but now have changed status, is known to the DBA. By default we list all un-acknowledged warnings or alarms in the “Alert Acknowledgement History” view. If…
Get instance configuration with CCC
Advanced Topics » Control Center Commandline » Get instance configuration with CCC
Prerequisites Before you can get instance configuration through CCC you need to go through the steps described in Setting up a CCC node Getting instance configuration get_instance.script has the following input parameters: server – specify server IP and port,…
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…
Dashboards
Customization » Web server » Dashboards
Dashboard overview The main page for the dashboards: User and login To view dashboards, you need to login with a user that has at least read privileges on web. Default dashboards These are the default dashboards: Instance status: This dashboard…
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…
Adding an Oracle Instance
Using Control Center » Instance management » Adding an Oracle Instance
Oracle Prerequisites !1. Oracle databases need to have a listener process running and also allow for an external login with sysdba user or user with enough privileges. 2. You need a privileged user, such as sys as sysdba, another user with sysdba privileges or…
Notes
Using Control Center » Monitoring » Job concepts » Notes
Notes on jobs are information that DBA’s and the Control Center system save to better document a system setup and known behaviour. When you open notes on a job, it will start off as a blank note. The top field is for personal notes and the contents are stored…
Database statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database statistics
Name: Database statistics Platform: Sqlserver Category: Availability Description: This procedure gathers statistics per database. Long description: Version: 1.8 Default schedule: 0 5 6…
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…
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…
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 backup
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Sybase » Database backup
Name: Database backup Platform: Sybase Category: Availability Description: Checks backup status of all databases. Long description: Version: 1.1 Default schedule: 50 5 *…
Control Center Commandline
Advanced Topics » Control Center Commandline
CCC.exe – the Control Center Commandline CCC.exe is a command intended to run on the commandline or terminal to trigger USL scripts. The intention of CCC is to use it for integration and automation purposes to access the capabilities of dbWatch for other 3rd…
DBMS uptime
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » DBMS uptime
Name: DBMS uptime Platform: Postgres Category: Availability Description: Collects database uptime statistics. Long description: Collects database uptime statistics. Version: 1.4 Default…
Database status
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Sybase » Database status
Name: Database status Platform: Sybase Category: Availability Description: Checks status of all databases defined on the system. The following incidents triggers a warning or an alarm: Long…
DBMS uptime
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Sybase » DBMS uptime
Name: DBMS uptime Platform: Sybase Category: Availability Description: Collects database uptime statistics. Long description: Version: 1.2 Default schedule: * * * Requires…
Post implementation
Customization » Monitoring » Editor for engine jobs » Post implementation
“Post implementation “is used to do actions after implementation steps. It can be recompiling code, fixing issues in data, or adding data to tables. In this example, it is a procedure that goes through the parameters configured and makes sure they are…
DBMS uptime
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » DBMS uptime
Name: DBMS uptime Platform: Mysql Category: Availability Description: Collects uptime statistics in the database. Long description: Task collecs uptime data statistics in the database…
Database status (MS2000)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database status (MS2000)
Name: Database status Platform: Sqlserver Category: Availability Description: Checks if all databases have status ONLINE Long description: Version: 2 Default schedule: 0 * *…
Database Server uptime (MS2000)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database Server uptime (MS2000)
Name: Database Server uptime Platform: Sqlserver Category: Availability Description: Collects database server uptime statistics. Long description: Version: 1.9 Default schedule: * *…
Backup check – pg_dump
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Backup check – pg_dump
Name: Backup check – pg_dump Platform: Postgres Category: Availability Description: Checks that there exists an up to date backup file. Long description: Checks that there exists an up to date backup…
DBMS uptime
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » DBMS uptime
Name: DBMS uptime Platform: Mariadb Category: Availability Description: Collects uptime statistics in the database. Long description: Task collecs uptime data statistics in the database…
DBMS uptime (old)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » DBMS uptime (old)
Name: DBMS uptime Platform: Mariadb Category: Availability Description: Collects uptime statistics in the database. Long description: Task collecs uptime data statistics in the database…
Listener log check (java 10g)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Listener log check (java 10g)
Name: Listener log check (java) Platform: Oracle Category: Availability Description: This checks and reads errors in database listener log. Using embedded java to read. Long description: Task checks and reads…
Database server uptime
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database server uptime
Name: Database Server uptime Platform: Sqlserver Category: Availability Description: Collects database server uptime statistics. Long description: Version: 2.2 Default schedule: * *…
Database server uptime (MS2005)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database server uptime (MS2005)
Name: Database Server uptime Platform: Sqlserver Category: Availability Description: Collects database server uptime statistics. Long description: Version: 2.2 Default schedule: * *…
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…
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…
Status
Using Control Center » Monitoring » Job concepts » Status
Jobs can have four different statuses. Additionally, the instance can have the “Lost connection” state, blue, that takes precedence over job statuses. Green for OK, Yellow for Warning, and Red for Alarm. Tasks can be without status, and the no-status icon…
Test alert
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Test alert
Name: Test alert Platform: Oracle Category: Availability Description: Test alert that alerts every ‘X’ minutes. Long description: Test alert that alerts every ‘X’ minutes. Usefull for…
Instance status
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Instance status
Name: Instance status Platform: Sqlserver Category: Availability Description: This alert checks if the instance has been restarted since the last check 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…
Restricted Enterprise edition features
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Restricted Enterprise edition features
Name: Restricted Enterprise edition features Platform: Sqlserver Category: Availability Description: Checks if there are any restricted features in use (supported only by Enterprise or Developer SQL Server…
Restricted Enterprise edition features (MS2000)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Restricted Enterprise edition features (MS2000)
Name: Restricted Enterprise edition features (2000) Platform: Sqlserver Category: Availability Description: Checks if there are any restricted features in use (supported only by Enterprise or Developer SQL Server…
Restricted Enterprise edition features (MS2005)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Restricted Enterprise edition features (MS2005)
Name: Restricted Enterprise edition features 2005 Platform: Sqlserver Category: Availability Description: Checks if there are any restricted features in use (supported only by Enterprise or Developer SQL Server…
Backup check – WAL
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Backup check – WAL
Name: Backup check – WAL Platform: Postgres Category: Availability Description: Checks that the WAL files have been backed up. Long description: Checks that the WAL files have been backed…
Schedule
Using Control Center » Monitoring » Job concepts » Schedule
The scheduling in Control Center has two modes, cron schedule, and interval schedule. Cron schedule The cron schedule is loosely based on the crontab format used on Unix systems. We have 4 fields that can be set, “Minute”, “Hour”,…
Test alert db
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Test alert db
Name: Test alert db Platform: Oracle Category: Availability Description: Test alert that alerts every ‘X’ minutes. Long description: Test alert that alerts every ‘X’ minutes. Usefull for…
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…
Program status
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Program status
Name: Program status Platform: Sqlserver Category: Availability Description: Checks for any program connected to the SQL Server by checking the program_name column in the master.dbo.sysprocesses table. Long…
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…
Instance error log
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Instance error log
Name: Instance error log Platform: Sqlserver Category: Availability Description: Reads and checks the Instance error log file by using the sp_readerrorlog stored procedure. Long description: The sp_readerrorlog…