We are using BODS for triggering a Stored procedure to execute a SQL Code.
As BODS can not capture the SQL Execute Status, we can not capture the Status of the procedure run Status / Execution Status.
Please need help provide some way on SQL Server to find the
Last 10 Run Status of a Stored Procedure ???
Procedure name, Date of Execution, Executed Session, Procedure Status (Success/Failed/Aborted...)
Thanks in advance