SQL Server Performance Forum – Threads Archive
Windows 2003 Scheduled Task Setting for SQLClusterI’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.
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.