Monday, February 18, 2008

Sql Alert- unable to delete job

Error in deleting sql agent job, due to the server name changed. To solved:-

use msdb
update sysjobsset originating_server ='rxxxx1'where job_id='A0AE2856-B477-4249-8E5B-64AA20D8610D'

Then use the sql agent GUI to delete the jobs.

No comments: