I can receive emails if I run the "Test" option int he email configuration page, but if I setup a task to run query dat deployment, the query runs but the email fails with
4/5/12 10:50:26 AM Started: Run Query
4/5/12 10:50:26 AM Completed: Run Query (The query 'VSE: DAT Deployment' was run as a scheduled command or part of a scheduled command chain. )
4/5/12 10:50:26 AM Started: Email File - email@example.com,
4/5/12 10:50:27 AM Failed: Email File was unsuccessful due to an unknown error. Incorrect syntax near ')'.
4/5/12 10:50:27 AM MONTHLY DAT DEPLOYMENT EMAIL (Email File was unsuccessful due to an unknown error. Incorrect syntax near ')'.)