Skip to Content

SQL Server environment variables

The following table lists the supported environment variables for Microsoft SQL Server databases, for each BMC Database Automation (BDA) activity:

Warning

Note

Beginning with BDA 8.8, a new GAC_Max_Wait_For_AvGrp_Synchronization custom variable enables you to specify the maximum polling time (in seconds) when BDA polls the Availability Group to see if all its databases are synchronized before proceeding to the patching operation.

For more information, see Installing-a-SQL-Server-patch-package.

In general, when specifying custom variables with the GAC prefix, use the following syntax:

  • For script Actions on Unix-like operating systems, ${GAC_variablename}
  • For script Actions on Windows operating systems, %GAC_variablename%
  • For SQL Actions, {GAC_variablename}

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC Database Automation 8.8