We help IT Professionals succeed at work.

SQL Server 2005 - Maintenance Plans Check

Medium Priority
183 Views
Last Modified: 2012-05-12
I've got some general maintenance plans setup for several databases I'm running on one SQL 2005 server.  I believe the jobs are running normal with no errors.  Where do I go wihtin SQL Management studio to see the listing of all the jobs, when they last ran, whether they were successful, and next run date.  Its easy to view this in SQL 2000.  I can't believe it wouldn't be easier within SQL 2005.
Comment
Watch Question

Chris MangusDatabase Administrator
CERTIFIED EXPERT
Commented:
A quick way is to run EXEC dbo.sp_help_job from msdb.
Thanks...actually you can just click on Activity Monitor to view all the jobs and their success/failure under one simple pane.  So it is just as simple as SQL 2000.  Run a command/script is not something I shy away from, but why do it if you have a simple one click within Studio Manager.

Author

Commented:
I'm selecting my own answer.  In the time I waited for a response, I found my own answer.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.