Mirroring: Jobs on Secondary Server
Posted on 2011-10-06
SQL SERVER 2008 R2
I'm starting to set up a couple of SQL boxes as primary and secondary in a mirroring configuration. There are actually no DBs on them yet, as I'm going to be first migrating a couple of databases from a 2005 box, then setting up the mirroring later.
But I'm starting to wonder how some of this will work, and I'd like to hear from some of you with experience.
Today, my question is this: I have a dozen or so jobs that execute stored procs within my soon-to-be-mirrored databases. In the event of failover, I would still need these jobs to execute on the secondary server.
But I don't need them executing BEFORE there's a failover.
How do I accomplish that? How do I make it so that *after* failover, my jobs on the secondary server begin working--but not BEFORE failover?