0

I've recently moved from using SQL 2000 Enterprise Manager to SQL 2008 R2 Management Studio.

I am administering the SQL Agent Jobs of a remote SQL 2000 Server and need to find the Next Run details of several of the Jobs.

In Enterprise Manager when selecting the Jobs node of the tree view, all the jobs are listed in a grid which includes the Next Run Date.

In Management Studio the jobs are listed in the tree view and I can find no way of accessing the Next Run info.

I have tried the Object Explorer Details view but this only includes Name, Status and Policy Health State columns.

Is there any way to view this info in SQL Management Studio?

1 Answer 1

1

Did you try the Job Activity Monitor under SQL Server Agent?

2
  • I get an error: Cannot show requested dialog. - Additional information: - Unable to execute requested command. - jobs (SqlManagerUI)
    – Shevek
    Mar 2, 2011 at 14:59
  • OK, it's because I am using the SQL Express Advanced version of SSMS. This doesn't support Job Activity Monitor (connect.microsoft.com/SQLServer/feedback/details/354939/…)
    – Shevek
    Mar 4, 2011 at 12:26

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .