How can we help you today? How can we help you today?

Running scripts in Multiscript sequentially

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
0

Comments

5 comments

  • chriskelly
    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
    0
  • gsc_ghx
    Thank you. Is there a way to have MultiScript report how long it takes to run scripts?
    gsc_ghx
    0
  • gsc_ghx
    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
    0
  • chriskelly
    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
    0
  • gsc_ghx
    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
    0

Add comment

Please sign in to leave a comment.