Scheduling Multi Script jobs

Single-click script execution on multiple SQL Servers.

Scheduling Multi Script jobs

Postby screenshot » Wed Mar 07, 2012 12:36 am

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)
Posts: 1
Joined: Wed Mar 07, 2012 12:28 am

Postby dlkj » Thu Mar 08, 2012 10:48 am

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:
Posts: 151
Joined: Tue Aug 14, 2007 4:10 pm
Location: Red Gate Software, Cambridge


Postby CDBA » Tue Dec 04, 2012 5:34 pm

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.
Posts: 1
Joined: Tue Dec 04, 2012 4:54 pm

Re: Scheduling Multi Script jobs

Postby Bigboss01 » Sat Dec 13, 2014 7:42 am

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?
You can get score highest marks in MB6-871 dumps dumps exam using and test king which are prepared by ku certified professionals ccna wireless Northwestern University
Posts: 2
Joined: Fri Dec 12, 2014 9:21 am

Return to SQL Multi Script 1

Who is online

Users browsing this forum: No registered users and 0 guests