One of the Job was failing with the below error-
Message:
Unable to connect to SQL Server’<XXXXXXXXXXXXX>’. The step failed.
Unable to connect to SQL Server’<XXXXXXXXXXXXX>’. The step failed.
So to resolve this issue:
1.I have went through the SQL server agent jobs->opened the job and verified that the job was not pointing to any database however the command was doing execution of stored procedure.
2. Verified that recently the database migrated to new server and database was dropped from existing server.(I have verified when the job was last successful ran).
Hence the above error has been written in the log.
So ensure when ever if you are going to migrate to new server or dropping database(s) -identify the Jobs and take the necessary actions.
No comments:
Post a Comment