Search
Related topics are listed below.
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 Agresso (part of the Agresso Application Package) Agresso reports queue Monitors and checks pending or running reports. Returns warning or alarm if the elapsed time exceeds defined…
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 Agresso (part of Agresso Application Package) Agresso report queue Monitors and checks pending or running reports. Returns warning or alarm if the elapsed time exceeds defined…
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…
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…
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…
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…
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”…
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…
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…
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…
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…
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 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…
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…
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,…
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…
Agresso framework
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Agresso framework
Name: Agresso framework Platform: Sqlserver Category: Agresso Premium package: Agresso application package Description: Checks whether there is an installation of the agresso application in any of the…
RMAN ARCHIVELOG backup status alert
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » RMAN ARCHIVELOG backup status alert
Name: RMAN ARCHIVELOG backup status alert Platform: Oracle Category: Availability Description: Checks the ‘soft limit’ and the ‘hard limit’ of the maximum number of physical OS files, that can be…
Index status check (8i)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Index status check (8i)
Name: Index status check Platform: Oracle Category: Maintenance Description: Detecting indexes in status UNUSABLE Long description: Detecting indexes in status UNUSABLE Version: 1.5 Default…
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…
Agresso CON$ system table
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Agresso CON$ system table
Name: Agresso CON$ system table Platform: Oracle Category: Agresso Description: Checks the size of all indexes defined on SYS.CON$ system table. Long description: Checks the size of all indexes defined on…
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…
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…
Instance Authentication Mode
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Instance Authentication Mode
Name: Instance Authentication Mode Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks if the Server Authentication property is set to ‘Windows…
Asymmetric Key size
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Asymmetric Key size
Name: Asymmetric Key size Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks that at least a 2048-bit encryption key size is used for asymmetric keys.…
Symmetric Key encryption
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Symmetric Key encryption
Name: Symmetric Key encryption Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks that only AES_128, AES_192, and AES_256 symmetric key encryption…
Table size collector
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Table size collector
Name: Table size collector Platform: Sqlserver Category: Capacity Description: Collects table (HEAP and CLUSTER type) size statistics. Long description: Collects table (HEAP and CLUSTER type) size statistics..…
Deadlocks event collector
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Deadlocks event collector
Name: Deadlocks event collector Platform: Sqlserver Category: Availability Description: Collects deadlocks event statistics from Microsoft SQL Server Extended Event Log files. If configured a warning or an alarm can be…
Full-Text service account
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Full-Text service account
Name: Full-Text service account Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks if the service account used by the Full-Text service account is not a…
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 compatibility
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database compatibility
Name: Database compatibility Platform: Sqlserver Category: Security Description: Checks if there is a difference in compatibility levels of databases and the instance. Long description: Checks if there is a…
Default trace enabled
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Default trace enabled
Name: Default trace enabled Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks that ‘Default Trace Enabled’ server configuration option is set…
Cross DB Ownership Chaining
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Cross DB Ownership Chaining
Name: Cross DB Ownership Chaining Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks cross-database ownership chaining across all databases at the…
Windows BUILTIN groups
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Windows BUILTIN groups
Name: Windows BUILTIN groups Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks that Windows BUILTIN groups are not SQL Logins. Long…
Windows LOCAL groups
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Windows LOCAL groups
Name: Windows LOCAL groups Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks that Windows LOCAL groups are not SQL Logins. Long…
Scan for startup procs
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Scan for startup procs
Name: Scan for startup procs Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Check if MS SQL Server automatically scan and run all stored procedures that are…
Password expiration (sysadmin)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Password expiration (sysadmin)
Name: Password expiration (sysadmin) Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks that CHECK_EXPIRATION option is set to ‘ON’ for all…
Auto close database
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Auto close database
Name: Auto close database Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks if the contained databases are closed or not after a connection…
Agresso – missing system indexes
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Agresso – missing system indexes
Name: Agresso – missing system indexes Platform: Sqlserver Category: Agresso Premium package: Agresso application package Description: Checks if there are any missing system indexes in the agresso…
Autoshrink settings
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Autoshrink settings
Name: Autoshrink settings Platform: Sqlserver Category: Maintenance Description: Checks if all databases have auto-shrink turned off. Long description: Checks if all databases have auto-shrink turned off. Only…
Contained database credentials
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Contained database credentials
Name: Contained database credentials Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks if the database users in contained databases are using database…
CLR Enabled
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » CLR Enabled
Name: CLR Enabled Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks if the assemblies can be run by SQL Server. Long description: Checks if…
Public server role
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Public server role
Name: Public server role Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks if extra permissions have been granted to the public server role.…
Login audit setting
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Login audit setting
Name: Login audit setting Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks if the SQL Server login audit is set to value ‘2’ (none = 0,…
Database Mail XPs
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database Mail XPs
Name: Database Mail XPs Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks the ability to generate and transmit email messages from SQL Server.…
Remote access
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Remote access
Name: Remote access Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks if local stored procedures can execute on remote servers or remote stored…
Agresso – missing user indexes
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Agresso – missing user indexes
Name: Agresso – missing user indexes Platform: Sqlserver Category: Agresso Premium package: Agresso application package Description: Checks if there are any missing user indexes in the agresso database by…
Agresso reports queue
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Agresso reports queue
Name: Agresso reports queue Platform: Oracle Category: Agresso Description: Monitors and checks pending or running reports. Returns warning or alarm if the elapsed time exceeds defined threshold. Long…
AG synchronization lag
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » AG synchronization lag
Name: AG synchronization lag Platform: Sqlserver Category: Cluster and Replication Description: Checks AG synchronization lag. Long description: Checks AG synchronization…
Command shell setting
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Command shell setting
Name: Command shell setting Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks if the xp_cmdshell is enabled, as a security best practice it is…
Guest database users
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Guest database users
Name: Guest database users Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks that CONNECT permission (in every non system database) are revoked for the…
Trustworthy
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Trustworthy
Name: Trustworthy Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Check if the TRUSTWORTHY database option allows database objects to access objects in other…
Remote admin connections
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Remote admin connections
Name: Remote admin connections Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks whether a client application on a remote computer can use the Dedicated…
AlwaysOn differential database backup alert
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » AlwaysOn differential database backup alert
Name: AlwaysOn differential 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…
Ad Hoc Distributed Queries
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Ad Hoc Distributed Queries
Name: Ad Hoc Distributed Queries Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks if the OPENROWSET and OPENDATASOURCE functions can be used to connect…
Test alert
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Test alert
Name: Test alert Platform: Sqlserver Category: Availability Description: Test alert that alerts every ‘X’ minutes. Long description: Test alert that alerts every ‘X’ minutes. Useful for…
Agresso report queue
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Agresso report queue
Name: Agresso report queue Platform: Sqlserver Category: Agresso Premium package: Agresso application package Description: Monitors and checks pending or running reports. Returns warning or alarm if the elapsed…
Orphaned database users
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Orphaned database users
Name: Orphaned database users Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks if there are orphaned database users (users for which the corresponding…
Disabled sa account
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Disabled sa account
Name: Disabled sa account Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks if the ‘sa’ login account (principal_id=1 and sid=0×01) is…
Number of ERRORLOG files
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Number of ERRORLOG files
Name: Number of ERRORLOG files Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks the number of error log files created on the operating file…
Agresso help and temp tables
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Agresso help and temp tables
Name: Agresso help and temp tables Platform: Oracle Category: Agresso Description: Collects information about objects (temporary tables and help tables) created in the agresso application schema. Long…
Renamed sa account
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Renamed sa account
Name: Renamed sa account Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks if the standard ‘sa’ login account (principal_id=1 and…
Page verify option
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Page verify option
Name: Page verify option Platform: Sqlserver Category: Maintenance Premium package: Maintenance package Description: This job checks whether PAGE_VERIFY database option is set to CHECKSUM. This helps provide a…