Maintenance plan to run a script for multiple databases
Posted on 2011-02-21
Hi All, I need to run a script on many servers (Exec USP_XYZ) which will be doing a bunch of delete and copy commands in several tables.
The wizard which has the option to select multiple databases DOES NOT have the option to run scripts. Only backup, shrink, etc...
I do not wish to create a job for every database, is it possible to create a plan that will be running for each database without using the wizard? or even using the wizard, does anyone know how to run a "EXEC usp_proc" on mulitple databases?