SQL Server Performance

Windows 2003 Scheduled Task Setting for SQLCluster

Discussion in 'SQL Server Clustering' started by poshanchang, Oct 26, 2004.

  1. poshanchang New Member

    I'm using Windows Server 2003 System Scheduled Task to do the SQL database maintenance jobs and some system log maintenance jobs.

    My SQL Server is built on two DB servers in Active-Passive Cluster mode.

    My question is if I should set up my Scheduled Tasks on both servers? If Scheduled Task is cluster awared?

    Thanks a lot.
  2. Argyle New Member

    I would recommend using the SQL Serrver Agent to schedule SQL related tasks. The Agent is cluster aware and will failover together with the sql server instance and it's disks.

Share This Page