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

Login

Remember Me

Directory Tree

Directory

gigi19lic

Reviews(1)
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.