SSMS - Show job failures??

[Catadmin]

You know how in SQL 2000 EM, you could just open up the jobs and automatically tell from the big red dots which jobs failed and which jobs were successful in the last run? I'd like to see this in SSMS without looking at the History records. However, the only thing my SSMS tells me is whether a job is disabled (small red down-arrow) or not.

Does anyone know of a way to set the GUI to highlight jobs the way that SQL 2000 did or at least do something similar?

Thanks,



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[manmaria]

If you look at the Job Activity Monitor, it will show you the status of the latest job. If you have a failure Y'day but success today, it will show only success. To see the history, you have to view the history as you know.

HTH

 

[mrdenny]

Job Activity Monitor. Microsoft has streamlined down the amount of data that things pull from the SQL Server when you click on varios windows to put less load on the SQL Server, and less data traffic making it easier to manage remote SQL Servers.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com