Space banner This version of the product has reached end of support. The documentation is available for your convenience. However, you must be logged in to access it. You will not be able to leave comments.

SQL Server environment variables

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

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*