Running scripts in Multiscript sequentially

Single-click script execution on multiple SQL Servers.

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

Running scripts in Multiscript sequentially

Postby gsc_ghx » Tue Apr 05, 2011 5:14 pm

I noticed the other day when running 3 scripts in Multiscript that it did not run the scripts sequentially. I had script one return the date and time at start of the process, script 2 and 3 the release code that was applied to all the databases, script 4 return the date and time to get the end time. But when I executed - script one and script four ran at the same time - therefore the date time was the same. I wanted to see how long execution took to run all the scripts - as we have not found how to get Multiscript to tell us how long everything took to run.

How can I get Multiscript to run secquentially or to report the time the process took to run?

Thank you... :roll:
gsc_ghx
 
Posts: 51
Joined: Tue Dec 04, 2007 10:33 pm

Postby chriskelly » Wed Apr 06, 2011 7:28 pm

If you navigate to the Tools menu and select Application Options > Execution (towards the top of the form) and then select Serial Execution, then this will ensure that your scripts are run sequentially.
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Postby gsc_ghx » Wed Apr 06, 2011 9:44 pm

Thank you. Is there a way to have MultiScript report how long it takes to run scripts?
gsc_ghx
 
Posts: 51
Joined: Tue Dec 04, 2007 10:33 pm

Postby gsc_ghx » Wed Apr 06, 2011 9:48 pm

Chris - I have the optiono of Parallel Excecution. I have it set to run against 5 databases at a time. What I would like to know - I have 4 scripts - the first on is select getdate() - I want the time the process starts. Then the code release - 2 scripts - they are run properly - then I have script 4 - select getdate(). I want the time the whole process completes. What I saw when I used this theory last week was - Script 1 and Script 2 were both run at the same time - thereby giving me a start and finish time of less than a second.

Is there some way Multiscript can give me the time stats for the process?

Thanks
Geri
gsc_ghx
 
Posts: 51
Joined: Tue Dec 04, 2007 10:33 pm

Postby chriskelly » Thu Apr 07, 2011 9:49 am

Unfortunately, beyond the start time which is displayed in the "Scripts Executed" pane, this is not possible at the moment. I have raised an enhancement request with our developers so that they can look into implementing something(reference: SE-673).
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Postby gsc_ghx » Thu Apr 07, 2011 2:39 pm

Thank you. Any reason why script 1 and 4 are run at the same time and not after the completion of script 3?
gsc_ghx
 
Posts: 51
Joined: Tue Dec 04, 2007 10:33 pm


Return to SQL Multi Script 1

Who is online

Users browsing this forum: No registered users and 1 guest