durai nagarajan (5/21/2013)
Any problem in using Job Activity Monitor provided in sqlagent?.
Nope, Job Activity Monitor works fine, and it doesn't show these old jobs, but I would like to build my own queries around the job tables to make monitoring more flexible.
homebrew01 (5/21/2013)
I just filter them out of my query and ignore them.
Yeah I've resorted to this too, our longest job is a few hours, so I've been filtering out anything older than 1 day by using:
start_execution_date >= DATEADD(dd, -1, GETDATE())
I would still like to understand this though, and clean it up if possible without breaking things. I don't see that it would break anything, but being a production server I'm hesitant to do things I'm not 100% sure about.