We have SQL Server Agent jobs (SSIS jobs) in almost 30 servers. Now we plan to reduce 50% servers. So I like to move SQL Server Agent jobs (SSIS package, Job script & config files) from one server to another server without affecting existing jobs. Can you please let me know the best and easiest method for this task? Thanks.
All the server has
1. Two instances (A & B) of SQL Server 2008 R2.
2. Same Database and tables for ETL purpose
All the jobs enter records in one of the prod SQL box database or Oracle database.