This is very simple yet useful T-SQL command which you can use to find out failed jobs on your server. This query needs to execute from Query Analyzer and tested for version SQL Server 2000 & 2005 successfully.
/***********************************/ /***Query to find the failed jobs***/ /***********************************/ use msdb go select h.server as [Server], j.[name] as [Name], h.message as [Message], h.run_date as LastRunDate, h.run_time as LastRunTime from sysjobhistory h inner join sysjobs j on h.job_id = j.job_id where j.enabled = 1 and h.instance_id in (select max(h.instance_id) from sysjobhistory h group by (h.job_id)) and h.run_status = 0
This article will demonstrate a method of creating an Excel-based CPU/scheduler performance dashboard for SQL Server 2005+.
2012-10-04
9,118 reads
Don't like the blackbox approach of maintenance plans? Like the maintenance plans but need a tweak to suit your needs? New author Robin Back has put together a monster script to allow you to build your own quickly and easily.
2003-08-20
9,698 reads
New author! Mike Pearson discusses how auto close was at the root of a performance problem he was troubleshooting, how you can check your servers easily, and discusses why both auto close and auto shrink are bad ideas in a production environment.
2003-05-05
21,111 reads
A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!
2003-04-18
18,229 reads
Have you ever had the problem where a user ran a query against your SQL Serer and crashed it or made the server unusable since the CPU was spiked at 100%? A SQL Server black box is the equivalent of a flight data record. The black box records all queries being passed to your SQL Server and other useful information like errors.
2003-04-11
15,285 reads
