when running job for sedning mails from SQL 2005 iam getting error like ,Executed as user: admin. INSERT failed because the following SET options have incorrect settings: 'ARITHABORT'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods. [SQLSTATE 42000] (Error 1934) Mail queued. [SQLSTATE 01000] (Error 0). The step failed.,00:00:01,16,0,,,,0

This issues can be solved by putting the command SET ARITHABORT ON before you call the SP for sending mail in the scheduler.

SET ARITHABORT ON