Scheduler

This guide explains how to configure and schedule a job. Users can create and schedule different job types, including database maintenance, data collection, and reporting.

Steps to Set Up a Scheduled Job

1. Enable the Scheduled Job

  • Toggle the Enable Scheduled Job switch to the ON position. This must be enabled to proceed with scheduling.

2. Enter Job Information

  • Name: Provide a meaningful name for the job (Required field).
  • Description: Optionally, enter a description to clarify the job's purpose.
  • Type: Select the appropriate job type from the dropdown menu (e.g., Database Maintenance, Data Collection, Reporting).

3. Configure Schedule Settings

  • Frequency: Choose how often the job should run (e.g., Daily, Weekly, Monthly, Custom Intervals).
  • Start Date: Select when the job should begin (Immediate or a specific date/time).
  • End Date: Set the job’s expiration (Never or a defined end date).

4. Time Zone Configuration

  • Ensure that the "Run this job using the scheduler service local time" toggle is set according to your requirements.

5. Save the Scheduled Job

  • Click Save to store the scheduled job.
  • Click Cancel if you do not want to save.

Job Type-Specific Configuration

Database Maintenance Jobs

SQL Server Maintenance plans are the preferred method of performing database maintenance. Cygna Auditor maintenance jobs may be used if the built-in SQL Server plans are not available. These jobs require db_owner permission for each selected database. The standard Cygna Auditor role is not sufficient. This Database Maintenance job will use a high volume of SQL Server resources while executing. Be sure to schedule this job when the expected SQL Server usage is low to reduce the impact on other operations.

  • Shrink Files: Enable this option to automatically reduce database file size if free space exceeds a set threshold.
  • Reduce Index Fragmentation: Enable this option and set a fragmentation percentage to optimize database performance.
  • SQL Operation Timeout: Define a timeout in minutes to limit execution time (0 disables the timeout).

Data Collection Jobs

  • Select a pre-configured data collector from the dropdown list (required).

Reporting Jobs

  • Select an existing report from the dropdown list (required).

Additional Notes

  • If the Save button is disabled, verify that all required fields are completed.
  • The job schedule can be modified later if needed.