I was checking one of our client’s DB server for the first time. I noticed a couple of their SQL Agent Jobs have been failing due to the error “Unable to connect to SQL Server ‘(local)’”
The reason for this error is because the Database (drop down box) to run the step from is empty.
The solution is to choose the relevant database to run the job step against.