If I may add a sub-question...
We backup our tlogs every 20 minutes, when the job fails (reason unimportant) we are notified via email/txt. Has anyone executed a scripted job to notify after a second failed job rather than the initial failure? Being that we backup every 20 minutes, we generally watch to see if the next backup succeeds and if so all is well, so to speak.
Is it actually worth trying to do such a thing? You do get notified twice within 20 minutes and, personally, I want to be notified of all such failures. I check the reason on the first failure because it's not always something that will all then next cycle to be successful.
is pronounced ree-bar and is a Modenism for R
First step towards the paradigm shift of writing Set Based code: Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Helpful Links:
How to post code problemsHow to post performance problemsForum FAQs