September 1, 2017
SQL Agent Error: unable to connect to sql server ‘(local)’. the step failed
Cause:
The error is caused by either database is not selected in Job Step or the database have been renamed.
Solution
“Edit Job Step” and select a database as shown below: