Post reply

Jobs on cluster server

  • December 30, 2003 at 1:50 pm

    #66238

    Supposing there are an active/passive SQL clustering servers and some jobs on active node. For some reason, the active done and the passive takes online. Do we need to modify jobs which working well on provious active server?

  • December 30, 2003 at 2:11 pm

    #488274

    If the active node is dropping are there any errors in the logs?

    K. Brian Kelley, GSEC

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/

    K. Brian Kelley
    @kbriankelley

  • December 30, 2003 at 2:37 pm

    #488285

    SQL Server jobs system works on virtual SQL Server name instead of physical server name. You don't have to modify jobs once SQL Server fails over, All jobs will be cancelled if they are running during the failover and You need to restart those jobs after failover.

  • December 30, 2003 at 2:48 pm

    #488287

    Bingo!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply