A great set of SQL Server automation tools has just been released by Microsoft onto the SQL Server Community Worldwide site...
http://sqlcommunity.com/ScriptsTools/OpsDBOperationsDatabaseforSQLServer/tabid/275/language/en-US/Default.aspx
These are excellent resources to add to your DBA toolset.