Hi,
I started getting this over the weekend and was wondering if there is some log or system table to look at because the alert is kind of useless to me if it doesn't give me the name of the job.
Thanks Guys!
Alert: Long Running Jobs
Source: SQLSERVERAGENT
Path: removed by sqlservercentral
Last modified by: System
Last modified time: 5/23/2010 11:22:36 PM Alert description: There are long running agent jobs on SQL instance MSSQLSERVER on computer SQL2005.company.org. This may indicate an issue with one or more jobs.
Alert view link: "?DisplayMode=Pivot&AlertID={288b7d7c-dc3d-4de9-b637-ec29bca8922c}"
Notification subscription ID generating this message: {752198C2-4AEA-DC3B-1BD3-978E5F046857}