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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment