Viewpoint with jobs running for more than 2 hours
Posted: 05 Mar 2016 12:50
Hello,
I'm trying to create a viewpoint to see all jobs that have been running for more than 2 hours. The problem is that I don't even know how to get the runtime. The closest I got was by using a filter with:
Job Status = Executing
Average Runtime > 02:00:00
But unlike the alerts where "average runtime" means "current runtime", this one actually really means "average runtime" so I see jobs that historically run for more than 2 hours.
Thanks.
I'm trying to create a viewpoint to see all jobs that have been running for more than 2 hours. The problem is that I don't even know how to get the runtime. The closest I got was by using a filter with:
Job Status = Executing
Average Runtime > 02:00:00
But unlike the alerts where "average runtime" means "current runtime", this one actually really means "average runtime" so I see jobs that historically run for more than 2 hours.
Thanks.