Directory

gigi19lic

Listings(0)

Reviews(1)

Favourites(0)

MSSQL Job History

Some useful addons

bygigi19lic, January 21, 2014

You can add at the beginning of the SELECT 'SET rowcount 0', will eventually save some people, would of saved me :)

If you need it for the last hour, you can add something like the below at the end:

and [h].[run_time]>replace(CONVERT(VARCHAR(8),dateadd(hour,-1,getdate()),108),':','')

I have some jobs that when they fail, no matter if I fix the problem, I can't re-run them until next week, and I don't want to disble them and remember to enable them.

Nagios, the Nagios logo, and Nagios graphics are the servicemarks, trademarks, or registered trademarks owned by Nagios Enterprises. All other servicemarks and trademarks are the property of their respective owner. The files and information on this site are the property of their respective owner(s). Nagios Enterprises makes no claims or warranties as to the fitness of any file or information on this website, for any purpose whatsoever. In fact, we officially disclaim all liability. We do, however, think these community contributions are pretty damn cool. Website Copyright © 2009-2024 Nagios Enterprises, LLC. All rights reserved.