SQL Job Success but Step Fails to run

If you are configuring a T-SQL job step go to the Advanced Page and configure the "Run as user" to the login of your choice. enter image description here
If you are working with other job step types like PowerShell it will require a proxy account to be configured.

Comments