the sproc executes fine & sends the email with the attachment when called from management studio so I would say the sproc and the call to sp_send_dbmail within it are fine. When executing the job from sql server agent, the error mentioned in original email occurs.

Increased retry attempts to 10. No change.