list of all status values of ExecutionLog in SSRS | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

list of all status values of ExecutionLog in SSRS

Hi,
I need to know all the possible ‘Status’ values of the ExecutionLog in repoting services.
Is there any way to find it?
presently when i am using….. select
distinct Status from ExecutionLog
I get the list of values, but I want to get the Possible list of values.
Can any one help me out…??

See these are any help:
http://technet.microsoft.com/en-us/library/ms156500.aspx
http://www.sql-server-performance.com/articles/biz/execution_log_reporting_data_source_p1.aspx

When I am using select distinct I am getting these result…..
rsJobWasCanceled
rsInternalError
rsReportParameterValueNotSet
rsParameterError
rsReportTimeoutExpired
rsProcessingAborted
rsSuccess
rrRenderingError
But I want to get all the possible list. Is there any master table for this?
With regards

I believe this is the link I was looking for…….. :)
http://msdn2.microsoft.com/en-us/library/aa256058(SQL.80).aspx

That is specific to SQl2000 version and you should mention that before in order to referring sql2005 links.

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |