I am trying to build a script that will return a dynamic set of results. The VBscript is going to go out to a database and retrieve SQL Agent names and run statuses. The challenge is I won't always know the names of the Agent jobs as we have hundreds of SQL Agent Jobs on a single SQL instance. Therefore they may change at times. I would like to return a result set to Orion in the following format
Statistic.NameOfSQLJob: 1
Message.NameOfSQLJob: Success
Where "NameOfSQLJob" will be dynamic.
When I Execute my code without a result set defined I get the error: "Windows script execution error. Script output values are not defined or improperly defined."
How do I return dynamic result sets?