Also, note the threshold being checked:

'WHERE

b.Sql_Severity <> 0

AND run_date = REPLACE(CONVERT(VARCHAR(10),GETDATE(),121),''-'','''') '+

'AND [run_time] >= '''+REPLACE(CONVERT(VARCHAR(20),DATEADD(minute, -20,GETDATE()),08),':','')+''''+

' ORDER BY [run_date],a.[Name],b.[step_id] '

This only goes back 20 minutes, if you want...

I'll recheck one last time to be sure. I've got to ask: you did create the stored-procedure and are executing it correct?

Really appreciate your quick responses. I'll again run that code of yours, onto other servers, and check the response. What about the e-mail part it should mail me, there is...

Won't this work (slightly different than what's posted)? - can't say I've ever noticed a count not equaling a select COUNT on a table directlySELECT ps.row_count

FROM sys.indexes AS i...

Do you have any errors to report? I tested the code before I posted it, it does work fine - if there are no failed jobs on the server...

It should be quite simple to modify the code to execute against your linked servers...

Example:INSERT INTO #SQLAGENTERRORS

EXECUTE [LINKSERVER].MASTER..SP_EXECUTESQL @sqlSelect

Thanks for the replies, I'll dig a tad further to see where it goes 😉

I see your point, but this table has nearly 700,000 rows, and in the execution plan it's using the non-clustered index (not the clustered).

If I drop the constraint altogether, it...

Sorry to hijack...

Create a simple SSRS report (RDL file) and call the stored-procedure running this code, format the report to your liking. Reporting Services is pretty straightforward...

This isn't "pretty" code but it works and will email you the results (I have it running hourly). I just set up a simple SQL Agent job on each...

Try wrapping the string in double-quotes:

insert into [SS-PC1]..SCOTT.TABLE1 values('"This is test command"',100000);

I used to get this all the time due to having Redgate SQL Prompt installed, I uninstalled that software and SQL Server, reinstalled both pieces of software and the issue...

Keep in mind these statistics are cumulative and only show...

Seems to be more of an issue with the precision you are setting with your decimal data type i.e. (9,2) - determine the maximum number of decimal places in the...