2005 Management Studio: Jobs Details (summary page)

9 Nov 2005 5:17 AM

TomT

I'm missing the info I got from EM on jobs, in the summary page, e.g. when a
job was last run, success/failure, scheduled, enabled, etc.

I don't see any way to add these columns on the summary page in Managment
Studio, am I missing something, or is this info not available there?

Thanks

Tom

9 Nov 2005 9:27 AM

Steen Persson (DK)

TomT wrote:

> I'm missing the info I got from EM on jobs, in the summary page, e.g. when a
> job was last run, success/failure, scheduled, enabled, etc.
>
> I don't see any way to add these columns on the summary page in Managment
> Studio, am I missing something, or is this info not available there?
>
> Thanks
>
> Tom

Tom,

Go to Object Explorer - SQL Server Agent - Jobs. Here you can right
click on the job and get the job history, properties etc. Pretty much
the same as you're used to on EM but it looks a bit different.

HTH

Regards
Steen

9 Nov 2005 11:29 AM

Michael Cheng [MSFT]

Hi Tom,

In SQL Server 2005, we use Job Activity Monitor to see following items

Name - Name of the job.
Enabled - Whether the job is enabled (yes) or not enabled (no).
Status - Current status of the job.
Last Run Outcome - Job status when last run.
Last Run - Date and time job was last run.
Next Run - Date and time the job is next scheduled to run.
Category - The job category assigned to the job.
Runnable - Yes if the job can be run; No if the job cannot be run.
Scheduled - Yes if the job is assigned to a job schedule; No if the job has
no schedule.

For more detailed information, check BOL or MSDN topic

Job Activity Monitor
http://msdn2.microsoft.com/en-us/library/ms188272.aspx

How to: View Job Activity (SQL Server Management Studio)
http://msdn2.microsoft.com/en-us/library/ms187449.aspx

Monitoring Job Activity
http://msdn2.microsoft.com/en-us/library/ms188272.aspx

How to: Set Up the Job History Log (SQL Server Management Studio)
http://msdn2.microsoft.com/en-us/library/ms175072.aspx

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!

Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.