SQL job is completing without sending email to configured recipients
The issue was the size limitation. We just made the file smaller using a shorter date range. Also changed size limit through sql function in case we wanted to select a larger date range later.

Reference: Database Mail Stored Procedures (Transact-SQL)

Particularly:


sysmail_help_configure_sp
sysmail_help_profile_sp
sysmail_help_account_sp
sysmail_help_principalprofile_sp
sysmail_help_profileaccount_sp