none
Cluster SQL Server Agent

    Pergunta

  • Hello,

    As SQL Server Agent jobs can run the DTExec.exe utility to execute SSIS packages, you can cluster SQL Server Agent to make sure that SSIS packages run on schedule when a failover occurs. When you cluster SQL Server Agent, SQL Server Agent jobs are available on all nodes. Therefore, the SQL Server Agent job can fail over between the nodes. The metadata of SQL Server Agent jobs is saved in the MSDB database. You can save your SSIS packages in the MSDB database or in a share disk.

    I have read this article, but didn't find the exact solution for how to do this.

    Can anyone help me on this. Thanks

    • Movido Iric WenModerator terça-feira, 5 de junho de 2012 09:10 (From:Transact-SQL)
    quinta-feira, 31 de maio de 2012 21:12

Respostas

Todas as Respostas