global update of Jobs | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

global update of Jobs

<br />Hi, <br /><br />we lost one of our servers and a number of sql jobs include the path to that server \oldserver. Is there a global way to change the name of the server from the oldname to the newserver name? The new server has exactly the same directory structure. We have about 30 jobs that are currently pointing to the old server and it sure would be nice not to have to open each one individually to change the path name.<br /><br />hope someone has run into this before… no, of course not, nobody else’s servers ever go down [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />thank you much,<br />Elle
When you say the "include the path".. could you be a bit more specific? Include it where – in a batch file, within a T-SQL Job Step, where exactly? And what is the path for – is it pointing at a location for disk backups, or what? Has the name of the server running the jobs changed? Tom Pullen
DBA, Oxfam GB
The best option is to SCRIPT out all the jobs and use notepad to modify the old servername to required servername on those .SQL files and reapply all back using MSDB database. HTH Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Hi and thanks for your suggestions. The path is in the Job that is a Planned Maintenance job… when you drill down into the step Execute master.dbo.xp_sqlmaint …blah blah…\unc_path..
I can look into unloading them to notepad and doing a replace. I’m not sure how that will work for sql maintenance jobs. I should have been more specific. Do you think that will work? Thanks