Post reply

SQL 2005 Server Agent Jobs view - want view like SQL 2000

  • April 16, 2007 at 6:05 am

    #116383

    In SQL 2005, Microsoft seems to have cleaned up the view for scheduled jobs (which in my case is not a good thing). 

    In SQL 2000 Enterprise Manager, you had columns for Job Status, Last Run Time, Next Scheduled Run Time, Enabled, etc...  This made it very easy to see the status of your scheduled jobs at a glance.

    Does such a view exist in SQL 2005 or am I forced to right-click and View History?  It would seem odd that Microsoft would remove such a useful view of scheduled jobs, but it wouldn't surprise me.

    Currently, when I go into SSMS, I only have the Status column, which only indicates whether the job is running or not.

    Many thanks in advance!

  • April 16, 2007 at 6:44 am

    #700667

    Matt,

    I'm not sure where you are looking but if you open "Job activity monitor" under SQL agent you should see all the information you are looking for.

    Markus

    [font="Verdana"]Markus Bohse[/font]

  • April 16, 2007 at 7:42 am

    #700682

    That's exactly what I'm looking for!

    Is there a way to incorporate this into a view (or have it automatically display in the Job Activity Monitor) so that I don't have to right click and choose View Job Activity?

    Thanks!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply