Home Directory

Search Exchange

Search All Sites

Nagios Live Webinars

Let our experts show you how Nagios can help your organization.

Contact Us

Phone: 1-888-NAGIOS-1
Email: sales@nagios.com


Remember Me

Directory Tree



bygigi19lic, January 21, 2014
MSSQL Job History
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.