Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

how to get the Last 10 Run Status of a Stored Procedure Expand / Collapse
Author
Message
Posted Sunday, December 8, 2013 6:37 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, March 6, 2014 11:47 PM
Points: 86, Visits: 214
Hi All,

Good Day...!

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 ???

Output

Procedure name, Date of Execution, Executed Session, Procedure Status (Success/Failed/Aborted...)

Thanks in advance
Post #1520864
Posted Sunday, December 8, 2013 10:16 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 7:13 AM
Points: 40,627, Visits: 37,092
Unless you have some custom logging implemented, you can't get that info. SQL doesn't track it.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1520873
Posted Sunday, December 8, 2013 10:47 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, March 6, 2014 11:47 PM
Points: 86, Visits: 214
Hi,

So you mean that we need to create Table / Process for logging in the Exeution Status of the Procedure.

Is that correct ???
Post #1520874
Posted Sunday, December 8, 2013 1:32 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 7:13 AM
Points: 40,627, Visits: 37,092
Yup, or set up an extended events session to run permanently. Dunno if the latter would meet your requirements though.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1520887
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse