How can I automate running a multi script across my estate and email or otherwise deliver the result
jgannon
Posts: 4 New member
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?
Tagged:
Best Answer
-
cperez Posts: 50 Bronze 2Hi 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.