Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 1 down vote accepted

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

share|improve this answer
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 (…) – Shevek Mar 4 '11 at 12:26

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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