What I really missed, though, was the Database Maintenance Plans. Recently, I found the answer — a great project created by Jasper Smith (sqldbatips.com) called ExpressMaint. The utility is available in both a command-line utility (great for Scheduled Tasks) or a TSQL stored procedure (which you could then schedule using the method above). The project is available at:
This does everything that the Database Maintenance Plans did, but easier to use in my opinion. It lets you do full backups, log backups, reindex, and check the database for integrety. It even has nice features like automatically deleting logs or backups older than x days.