Scheduling Multi Script jobs

screenshot

I don't see any option to schedule Multi Script jobs in the documentation. Am I missing something? I'd like to do my deployments to my many databases on many servers at 3am, without having to wake up to do it.

(I've not downloaded the tool yet as I'm waiting for something on my end before I start the trial period)

dlkj

Hi Screenshot,

Unfortunately SQL Multi Script isn't currently scriptable itself.

You might be able to rig up something to meet your needs using the windows scheduler and the sqlcmd command line utility:

http://msdn.microsoft.com/en-us/library/ms170207.aspx

CDBA

Really, is it so difficult to add scheduling feature? MultiScript is a fantastic tool but we will have to move away from it since we cannot schedule our scripts and produce saved results on daily basis (outside of business hours). I.e. I have 100+ SQL Servers and I need daily maintenance/backup status report at 6AM, thus by the time when everybody is at the office, DBA has a report which backup failed and what errors we found in error logs. I have no time to view logs manually, neither run the scripts during business hours.

Bigboss01

I want to save the results of several scripts i run at one time. I see I can save the results from EACH script - but I want to save the results for ALL Scripts into one file. Can that be done?