Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
carsip
Starting Member
2 Posts |
 Posted - 2002-10-02 : 12:19:12
|
| My company is currently running our production SQL databases on an older server, due to a crash of the original database server. We are scheduling the replacement of the "better" server since it has been fixed, and production performance is suffering. We currently have 49 jobs that run on a scheduled basis, via the SQLServerAgent. Is there a simple way that we can copy not only the schedule of these jobs, but the details/script of these jobs from one server to the other, without having to recreate each job on the new server after the upgrade occurs? At this point, I am being told that I must manually and individually recreate each job on the new server, after we restore the user databases. Please tell me that this isn't so!!!! |
|
|
dgaylor
Yak Posting Veteran
54 Posts |
Posted - 2002-10-02 : 12:23:54
|
| when i needed to do this i just went under each job/all tasks/generate sql script and then ran these to create on the new server |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
|
|
|
Server Replacements - must all jobs be recreated??