For my future reference (and yours as well), here is how to configure your SQL Server 2005 maintenance plans so that they operate correctly with MOSS.  A great post by Jingmei Li.

http://blogs.msdn.com/jingmeili/archive/2007/02/26/sql-server-2005-maintenance-plans-and-moss-2007-databases.aspx