Finding Failed SQL Server Jobs with SMO

This video show you how to find failed SQL Server jobs using SMO

Tim Mitchell is a Microsoft SQL Server database developer, business intelligence consultant, writer, and speaker. He has been working professionally with SQL Server for over six years, and holds the MCTS and MCDBA certifications from Microsoft as well as a Bachelor's degree in computer science from Texas A&M University - Commerce.

shashikant.262 on 11/21/2008

This video is good for understanding the basic logic of monitoring jobs using SMO. Can we perform this thing using T-sql in sql server 2000, 2005. There is a very simple way to monitor failure of jobs for all server using sql server 2008 Management Studio. Using Multi server query.

Sajid Chida on 11/22/2008

Thanks Tim. Is there a basic one for starters...how to code?

Tim Mitchell on 11/23/2008

Sajid, I have plans to compose one or more Programming Basics for DBAs lessons in the near future.

Rubens on 11/24/2008

Would love to see more videos using SMO. Great video, thanks!

ML Stephens on 2/9/2009

very clean concise presentation

Carlos B. Vasquez on 5/10/2011

It is a nice DBA tool.

Max Turavani on 5/10/2011

Nice!

D151BB6B9F on 5/10/2011

It'd be nice if we could download the code from these videos.

SQLSharma on 5/18/2011

We can download the code, and it is good!

Ludwig on 5/23/2011

How does it know all the SQL-Servers available? I guess I could pass in a table containing all the server names but that script didn't seem to do that... Thx Ludwig

Maurice Ivory on 10/21/2011

This presentation was most excellent. I will use this function in SMO.