SQL Server Job - Failing - Error: 4014, Severity: 20, State: 8.

 There are many reasons to fail the SQL Server job with this error code like -

1. Permission issue for the Job owner
2. Permissions for the SQL Server Agent account
3. Permissions on MSDB and User Datbases
4. Issues with the sp_send_dbmail parameters 

If above are proper please follow the below steps to identify the issue -

Open profiler and choose the below events and then run the job.

In our case this was the culprit.

Now fix the code and run the job, which will succeed.