The Multifunctioning DBA:

DB Online

1

June 22, 2011  11:00 PM

Check DB online before running Job



Posted by: Colin Smith
DB Online, T-SQL

I was also asked to make sure that I have jobs set up on my servers that have database mirroring set up. They only want the job to run if the database is online and they do not want to have to enable and disable jobs when failovers occur. So I did the following.

1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: