DECLARE @mailitem_id INT,
        @retcode INT;

EXECUTE @retcode = msdb.dbo.sp_send_dbmail @profile_name = 'mail',
                                           @recipients = 'test@test.com',
                                           @subject = 'subj',
                                           @body = 'body',
                                           @body_format = 'HTML',
                                           @file_attachments = 'c:\tmp\test.pdf',
                                           @mailitem_id = @mailitem_id OUTPUT;


SELECT @retcode,
       @@error;