2 of 2 people found this helpful
there are two types of actions: Script and SQL.
Script Actions are used to run scripts, on targeted hosts, using the BDA Management Console. For example, a Script Action can install an application’s agent on a server, and can include the agent installer package as part of the Action’s content.
SQL Actions allow you to run SQL code directly on a targeted database, using the BDA Management Console. For example, backing up a database, or changing a database configuration parameter. Note: SQL Actions cannot be used as Pre-provisioning or Post-provisioning scripts.
Both types of Actions can be used to deploy or update application schemas.
Refer BMC documentation for declaring , using out of the box variables starting with GA_ prefix and custom variables starting with GAC_
Below is an example of a script action, hope it helps.
Thanks for answer, what you recommend for i read, about creation of scripts for SQL Actions.