How can I automate running a multi script across my estate and email or otherwise deliver the result

jgannon

I'd like to use multi-script to run a query on all my servers and deliver the results to me automatically on a schedule. Has anybody tried that? 

cperez

Hi Jgannon,

Thanks for reaching out to Redgate with your multi-script automation request. The problem in this case is that SQL Multi-script does not have an API or Command Line inteface that can be used to kick off the job in an automated way.

A SQL Monitor custom metric maybe a better solution for you. If you'd like to investigate other options then raise a support ticket with support@red-gate.com 
 
You might be able to rig up something to meet your needs using the windows scheduler and the sqlcmd command line utility See, http://msdn.microsoft.com/en-us/library/ms170207.aspx. But this isn't something that we could support you with.