• Thanks Lowell, that does more than we need but it is a good starting off place, not so much craptastic at all!.  I also had the idea to let the dev team run it on-demand rather than in a schedule. They are SQLAgentOperator so that should work. We would have it also exclude any DBA maintenance jobs. I had thought to just have a @job_name as an input parameter, but then again whoever ran it could not alter it to add the parameter so that wouldn't work.