YChen, take a look at sp_add_maintenance_plan in SQL Server BOL. sqlmaint only executes the plan. I'm also figuring out how to create the plan by hand or get the wizard's...

Is it possible to convert the maintenance plan and the jobs created by this wizard to a SQL script that adds the same maintenance plan and jobs to an arbitrary...