framework

Job details

Parameters

Job Summary

• Purpose: The purpose of this job is to manage and maintain the dbWatch engine framework specifically for SQL Server 2000 instances. It includes creation and maintenance of various database objects and procedures as part of system infrastructure for monitoring and managing database health and performance.
• Why: This job is critical for ensuring the dbWatch platform is updated and able to effectively monitor the database systems it is tasked with. Regular updates and maintenance tasks such as patching or upgrading ensure that performance metrics and health checks are accurately gathered and reported.
• Manual checking: You can check the settings and configurations applied by this job manually in the server by inspecting the specific tables, views, and procedures that have been created or modified.

Details of Job Execution

• Component Query:
  • Filters the job execution to only SQL Server 2000 instances that are running SQL Server Engine.

• Task Description:
  • Name: framework
  • Description: Manages dbWatch engine framework for internal use. It is essential for applying patches or upgrades to the dbWatch engine to ensure efficient performance and accurate system monitoring.
  • Default Schedule: Runs on the first day of every month at 05:50 AM.

• Dependencies: The job has several operational dependencies which include other internal framework tasks and database objects needed for successful execution. Dependencies ensure that all related components are present and properly configured before the job execution.
  • Self-dependency on the framework task.
  • Dependencies on various internal objects used for tracking and management (e.g., dbw_weeks_fw, dbw_days_fw, etc.)

Implementation Details

This task involves several SQL operations such as creating stored procedures, tables, and views essential for the dbWatch system’s functionality:

• Creation of procedures and tables for handling framework tasks, such as logging task executions, registering tasks, and checking their conditions.
• Creating views to assist in the diagnosis and monitoring of tasks such as historical status, weekly warnings and alarms, and other performance metrics.
• Modifications and updates in procedures to patch or upgrade the engine framework to newer versions, thereby improving performance or fixing issues from previous implementations.

Report Template Overview

Provides a structured report outline for the dbWatch framework, detailing the version installed and tasks related to the framework.

• Title: Framework
• Description: Internally used report for monitoring the dbWatch engine framework.
• Default Schedule: Continuous monitoring is implied with a schedule set to every hour.

Upgrade and Installation Procedures

Details methods and scripts involved during the upgrade of dbWatch tasks and framework:

• Post-implementation steps include:
  • Updating task IDs and dependencies.

These steps are essential to ensure that after a version upgrade, the old settings and dependencies are cleared or updated to support new functionalities without conflict.

Express Installation

Indicates that there are facilities for express installation processes which might allow quicker deployment or updating steps skipping some of the conventional checkpoints or validations for rapid setup.

This job, overall, is vital to maintain the health and integrity of the dbWatch engine and the databases it monitors, ensuring that all monitoring and management tasks are up to date with the latest operational standards and technologies.