Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
SELECT TOP 1000 *
FROM maintenance_log l
INNER JOIN maintenance_log_section s ON s.maintenance_log_id = l.id
INNER JOIN maintenance_log_section_detail d ON d.maintenance_log_section_id = s.id
ORDER BY l.id DESC, s.id DESC, d.id DESC;

Always On Availability Groups

The Verba Maintenance SQL Agent Jobs are automatically created in the Primary Replica during the installation. The jobs must be created on the Secondary Replicas manually with the provided update-programs-maintenance-job.sql script.

The Jobs will be started on the Secondary Replicas too based on the schedule but will do nothing because the job checks the state of the replica and will immediately stop the execution on the Secondary Replicas. This way the jobs will be running on the new Primary Replica after a failover.

Changing the job schedule

...