SQL Server environment variables


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

Warning

Note

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.7