RunCommand macro at Cycle period level

The RunCommand macro used to run a command for a Data source. This is an extended version of the RunSQL macro.This macro supports Database and Supply Planning commands at the cycle period level that are not specific to the context of a scenario. The command updates static or configuration data in SCP or external data.

This table lists the parameters used to execute the RunCommand macro at cycle period level:


Parameter Name	Description
Data Source	The data source for which the command is executed. Select Database or Supply Planning.
Command Text	The command to execute for the specified data source.

The value for the Command field must be specified in this format: RunCommand (Data Source, Command Text).

This table lists the examples of the RunCommand macro:


Requirement	Syntax
Running the "reset" command on the "Test" data source	RunCommand("Test", "reset")

The command is executed for the specified Data source on successful validation and execution of the macro.

This table lists the Cycle Period status and the related validation messages:


Cycle Period Status	Scenario Status	Can Execute?	Validation Message
Any	Any	Yes	N/A

Validation is performed when you execute the RunCommand macro. If validation fails, the macro is aborted, and the related error message is displayed. This table lists the error messages displayed for various validation failures:


Validation Condition	Error Message
RunCommand supports data source type Supply Planning or Database only.	The RunCommand macro requires a data source of type Supply Planning or Database.
Check the data source is valid.	data source {0} cannot be found.
When Data Source type is set to Supply Planning, the second parameter must be a valid Supply Planning command. That means the parameter value must be in workflow: workflowname format. Else, the command is rejected and an error message is displayed.	Command {0} is not a valid for Supply Planning.