Managing scheduled async SQL Server tasks

  • Article

DBAs often struggle with setting up automated tasks for managing
databases such as taking backups, maintaining warehouses, re-building
indexes and generating scheduled reports just to mention a few. While
Service Broker is seen mostly as a framework for developers to build
reliable messaging applications, it can be used very well by DBAs for
doing routine maintenance jobs asychronously. Roger Wolter's recent
article on Microsoft TechNet Magazine (Spring 2005) talks about a simple
batch scheduling system built using Service Broker. You can access it
here:

Async Lifestyle: Manage Your Tasks With Service Broker