Build precise queries to find exactly what you need
Press ESC to close
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.
We’ve completely redesigned the world’s largest repository of Nagios plugins and monitoring tools. Join thousands of users sharing monitoring solutions for servers, applications, and everything in between.
Due to our redesign, all existing accounts require a password reset to access your account again.
Ready to explore 6,100+ projects and contribute to the community?
Reset Password Create Account
Happy Monitoring!