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

jgannonjgannon Posts: 4 New member
in SQL Multi Script
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:
· Share on Twitter

Best Answer

  • cperezcperez Posts: 43 Bronze 1
    Answer ✓
    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. 
    · Share on Twitter
Sign In or Register to comment.