One of the SQL backup job failing with the error : Unable to connect to SQL Server '(local)'. The step failed. . I was trying to take backup of ‘Test’ database, after seeing this error verified again and noticed the DB ‘Test’ exists and is accessible without any issue.
After verifying, noticed job step was configured in this way: