Red Gate forums :: View topic - Running scripts in Multiscript sequentially
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

Running scripts in Multiscript sequentially

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



Joined: 04 Dec 2007
Posts: 51

PostPosted: Tue Apr 05, 2011 5:14 pm    Post subject: Running scripts in Multiscript sequentially Reply with quote

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... Rolling Eyes
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 328
Location: Cambridge, UK

PostPosted: Wed Apr 06, 2011 7:28 pm    Post subject: Reply with quote

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



Joined: 04 Dec 2007
Posts: 51

PostPosted: Wed Apr 06, 2011 9:44 pm    Post subject: Reply with quote

Thank you. Is there a way to have MultiScript report how long it takes to run scripts?
Back to top
View user's profile Send private message
gsc_ghx



Joined: 04 Dec 2007
Posts: 51

PostPosted: Wed Apr 06, 2011 9:48 pm    Post subject: Reply with quote

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



Joined: 19 Apr 2010
Posts: 328
Location: Cambridge, UK

PostPosted: Thu Apr 07, 2011 9:49 am    Post subject: Reply with quote

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



Joined: 04 Dec 2007
Posts: 51

PostPosted: Thu Apr 07, 2011 2:39 pm    Post subject: Reply with quote

Thank you. Any reason why script 1 and 4 are run at the same time and not after the completion of script 3?
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