I want to execute a list of DB Stored procedures after executing a DM step in OS. Is it possible to call a DB Stored Procedure from OS?After the Stored Procedures are run, I want to execute a list of DM Jobs for data imports to cube.
Appreciate any pointers how I can implement this.
Solved! Go to Solution.
I am able to execute the stored procedure. Now as a next step I need to execute a Data Management job to import the data from DB to OS Cube.
Prior to that I need to check whether the stored procedure executed successfully without errors. How can I check for errors within the BR? The brapi.Database.ExecuteActionQuery command has a Boolean parameter to log errors. But I am not sure how I can access those error messages.