Scheduling Multi Script jobs

Single-click script execution on multiple SQL Servers.

Moderators: JonathanWatts, Anu Deshpande, dlkj, Colin Millerchip, Michelle Taylor

Scheduling Multi Script jobs

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

Postby dlkj » Thu Mar 08, 2012 11: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:

http://msdn.microsoft.com/en-us/library/ms170207.aspx
dlkj
 
Posts: 151
Joined: Tue Aug 14, 2007 5:10 pm
Location: Red Gate Software, Cambridge

Really

Postby CDBA » Tue Dec 04, 2012 6: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.
CDBA
 
Posts: 1
Joined: Tue Dec 04, 2012 5:54 pm


Return to SQL Multi Script 1

Who is online

Users browsing this forum: No registered users and 0 guests