Table FB_AGSystemDataJobExceptions

Previous Table FB_AGPostFailoverDBUsers	Large Scale Deployment Using SQL FineBuild Next

The FB_AGSystemDataJobExceptions table holds details of Jobs that should be allowed to run on a Secondary server

Proc FB_AGSystemData will set all Job Schedules on a Secondary Server to Disabled, to prevent work intended to be run only on the Primary server from running on a Secondary server. Any jobs that should be allowed to run on the Secondary server should be added to this table and will have their schedules enabled by FB_AGSystemData

If there are any site-specific Job Exceptions that need to be applied, they can be added to this table and will be processed automatically by Proc FB_AGSystemData. The site-specific values can be included in a SQL FineBuild install by using an AutoConfig Script

Column Name	Data Type	Description
Id	Integer	Identity value
AGName	NVarchar(128)	Availability Group Name
JobName	NVarchar(128)	Job Name

This table will be populated by SQL FineBuild with the following rows:

AGName	JobName
%	DBA: Create New Errorlog
%	DBA: Integrity Check - System Databases
%	DBA: Integrity Check - User Databases
%	DBA: Move Cluster Core

Copyright FineBuild Team © 2020. License and Acknowledgements

Previous Table FB_AGPostFailoverDBUsers	Top	Large Scale Deployment Using SQL FineBuild Next