• I like the idea and am thinking on using it in tasks other then index maintenance.

    One thing I would like to abstract away is parallelizing specific task, in this case Execute SQL task. DTS for SQL Server 2000 carries "Execute DTS Package" component, which fits rather well.

    Any suggestion implementing this software design pattern.

    -- Miron.