Mirroring Job Switcher

I wrote this so that jobs associated with a mirrored database will run on the principal and not on the mirror.  Please send your comments on what implications I might be missing - I would appreciate that greatly.This procedure works in conjunction with a WMI alert you will setup in SQLSEVERAGENT -> Alerts ->Mirroring Status […]

2007-09-04 (first published: )

458 reads

Blogs

Daily Coping 2 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Presenting on Ethics in Modern Data at Houston HASSUG/SQL BI Group July 2020 Meeting

By

Looking forward to presenting with my wife Christine Assaf our talk on Ethics in...

MVP for Another Year 2020-2021

By

Early this afternoon I received an email from Microsoft presenting me with the 2020-2021...

Read the latest Blogs

Forums

Daily Coping 2 Jul 2020

By Steve Jones - SSC Editor

Today’s tip is share a happy memory with someone who means a lot to...

Query taking more than 4 hrs. - Any recommendations/suggestions?

By Feivel

One of our stored procs has been running for more than 4 hrs. and...

Unusual use of the WHERE clause

By michael.leach2015

I am working an exercise problem where the solution provided has a WHERE clause...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers