Can’t drop or edit SQL Agent job after changing server name

Having trouble editing or dropping a job on a SQL Server that you renamed the NT server for?

Simply change the field below by running this query and every will work out.


UPDATE msdb..sysjobs
SET originating_server @@SERVERNAME
-- select *
FROM msdb..sysjobs WHERE originating_server 'sql1\i2k'

Comments are closed.

Post Navigation