How to Add/Remove the Server (Computer)?
There are some situations at which you need to Add/Remove the Server (Computer) to your SQL Server instance.
Here is a scenario. Your database server name is changed from Old_Server to New_Server. Even after changing your database server name, your SQL Server Instance will be pointing to the Old_Server name. This may affect the SQL Agent jobs.You may be facing problems in Add/Edit the scheduled jobs some times.
To avoid this you need to remove the Old_Server and add the New_Server name.
To know the current Server name run the below command:
To remove the Old_Server run the below command:
To add the New_Server run the below command:
After completing this process you will see that your SQL Agent Jobs will be start working fine.
For more information see the Microsoft links: