Table FB_AGSystemDataJobExceptions - SQL-FineBuild/Common GitHub Wiki
| 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 |
|---|