Enhancement Request

Single-click script execution on multiple SQL Servers.

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

Enhancement Request

Postby padwin » Wed Nov 25, 2009 5:34 pm

I would like to see a feature when in Multi Script you can create a job and schedule it to run like a Sql job but that runs thru Multi script.

For example: I'm querying 30 servers with Multi script and I want to schedule a job to execute this script and give me one file like it does in Multi script. Vs. Me, scripting a SQL job to run at the 30 servers and will give me 30 files when I just want one file. :wink: :P :lol:

This would make Multi Script even better utility for DBAs to use.
Padwin
padwin
 
Posts: 3
Joined: Fri Sep 04, 2009 2:38 pm
Location: Texas, US

Postby peter.peart » Thu Nov 26, 2009 7:28 pm

Hi Padwin,

I can certainly add this as a feature request in our systems, however how would you like to see this implemented?

Many thanks!

Pete
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids

Re: Enhancement Request

Postby padwin » Fri Nov 27, 2009 3:47 pm

I would certainly wold like this implemented as an option in Multi-script. Just as a Job agent that will in some way create a Task Scheduler type process where it will execute when scheduled.
Kind of like, SQL Jobs or like mentioned previously Task Scheduler.

Or perhaps maybe have an option to use Multi-script thru command line where we can create a batch file to give us the results.
Currently I use MassQuery in that way. :idea:
Padwin
padwin
 
Posts: 3
Joined: Fri Sep 04, 2009 2:38 pm
Location: Texas, US

Postby peter.peart » Fri Nov 27, 2009 3:55 pm

Hi Padwin,

I was thinking command line, but didn't want to influence you towards that :)

It isn't currently possible, but I have added it as a feature request for you with tracking number SE-643. I am sure it will be reviewed by the product management team for a future release of the tool.

Pete
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids


Return to SQL Multi Script 1

Who is online

Users browsing this forum: No registered users and 1 guest