Red Gate forums :: View topic - Scheduling Multi Script jobs
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Multi Script 1
SQL Multi Script 1 forum

Scheduling Multi Script jobs

Search in SQL Multi Script 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
screenshot



Joined: 07 Mar 2012
Posts: 1

PostPosted: Wed Mar 07, 2012 1:36 am    Post subject: Scheduling Multi Script jobs Reply with quote

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)
Back to top
View user's profile Send private message
dlkj



Joined: 14 Aug 2007
Posts: 151
Location: Red Gate Software, Cambridge

PostPosted: Thu Mar 08, 2012 11:48 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
CDBA



Joined: 04 Dec 2012
Posts: 1

PostPosted: Tue Dec 04, 2012 6:34 pm    Post subject: Really Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group