Hi, I would like to setup Multi Server Administration in our environment. I would like to create a maintenance plan for all the dbs on the master server and deploy them to the target servers. Unfortunately the backup location and error log location for all the servers vary. Is there a way that I can use variables that dynamically change the backup location and log location on each server? Any ideas would be of extreme help.
Hi Madduri, I believe you want to pass a parameter to each job. but how will you pass a value for an automated job? 1. Even though you mentioned as maintenance job, I am not sure whether you refer to an SSIS package We use something like this. We will have a table in the same database in each environment and read the value. Manually update the value in each environment On SSIS you can manually set the values for parameters (configurations).
Thank you for the reply. Yes, I was refering to creating a Maintenance plan job (using a wizard). Is there any way we can open and tweak the SSIS package configuration that gets created at the backend? else we have to script out and make modifications to the script.
True, with SSIS package you can do the tweaks and tricks refer this http://msdn.microsoft.com/en-us/library/ms189647.aspx and http://blogs.techrepublic.com.com/datacenter/?p=248 BTW, this can be done using scripts as well you just need to change the path have a look at script here http://surat-user-group.org/scripts.aspx