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?


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

  • I get an error: Cannot show requested dialog. - Additional information: - Unable to execute requested command. - jobs (SqlManagerUI) – Shevek Mar 2 '11 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 '11 at 12:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.