Windows 2003 Scheduled Task Setting for SQLCluster | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Windows 2003 Scheduled Task Setting for SQLCluster

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.
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.
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |