ExecuteFile - executing repeatedly

swilliams · Post by **swilliams** » Wed Jun 07, 2006 3:52 pm

We've packaged MacroScheduler so that some of our users who have restricted rights can schedule tasks.
A user is scheduling a macro which runs a BAT file (using ExecuteFile). The macro is scheduled to run on a number of days in the week at 23:50. Most (but not all of the time) it seems to start several instances of the BAT file. "0" has been left in the "repeat every x minutes" box. The recovery parameter is left as default (run at scheduled start time). I've tried scheduling at 8:00 and we get the same issue, so it isn't anything to do with the date rollover.

We are using an older version (7.3) but I can't see anything in the logs that looks like it fixes this, so I think it's more likely to be the way we're using the app. - can you help?
________
TOYOTA MC PLATFORM

JRL · Post by **JRL** » Wed Jun 07, 2006 4:36 pm

You didn't mention what happens if you run the script manually. It could be an error in the script or even an error in the BAT file.

Just as thought,
Dick

swilliams · Post by **swilliams** » Wed Jun 07, 2006 4:45 pm

Nice idea, but running the BAT file manually works with no problems.
Sandra
________
Sc2 replays

JRL · Post by **JRL** » Wed Jun 07, 2006 4:56 pm

Is there an "advanced options" button under the "Run When" tab in v7.3? I don't recall. If there is, it there possibly a window event set?

Is the script running the bat file using the ExecuteFile> function rather than the Run Program> function?

Could you post the script?

Later,
Dick

swilliams · Post by **swilliams** » Wed Jun 07, 2006 5:27 pm

Dick,
The Advanced schedule tab looks just the same as in the current on-line help.
The 'when system restarts' button is set to "Run macro at scheduled start time"
The script is attached below. NB "S" is a remote server. What's happening is that more than one instance of the BAT seems to be starting.

Code: Select all

rem Set Up The User's Output Directories. We have a set for each Book ********

rem Daily Risk Directories - One Per Book

MkDir "S:\FXO\batch\Daily_Risk\ASIA_FLOW\"
MkDir "S:\FXO\batch\Daily_Risk\ASIA_GENIE\"
MkDir "S:\FXO\batch\Daily_Risk\ASIA_SPG\"
MkDir "S:\FXO\batch\Daily_Risk\BRAZIL_FX\"
MkDir "S:\FXO\batch\Daily_Risk\C4\"
MkDir "S:\FXO\batch\Daily_Risk\COMPLEX\"
MkDir "S:\FXO\batch\Daily_Risk\CROSSES\"
MkDir "S:\FXO\batch\Daily_Risk\EMEA_CPX\"
MkDir "S:\FXO\batch\Daily_Risk\EMEA_FLOW\"
MkDir "S:\FXO\batch\Daily_Risk\FX_PROP\"
MkDir "S:\FXO\batch\Daily_Risk\G5\"
MkDir "S:\FXO\batch\Daily_Risk\GENEVA\"
MkDir "S:\FXO\batch\Daily_Risk\INACTIVE\"
MkDir "S:\FXO\batch\Daily_Risk\LTM_GCO\"
MkDir "S:\FXO\batch\Daily_Risk\LTM_GXO\"
MkDir "S:\FXO\batch\Daily_Risk\LTM_RC\"
MkDir "S:\FXO\batch\Daily_Risk\MAN\"
MkDir "S:\FXO\batch\Daily_Risk\OTHER\"
MkDir "S:\FXO\batch\Daily_Risk\RETAIL\"
MkDir "S:\FXO\batch\Daily_Risk\SPOT\"
del "S:\FXO\batch\Daily_Risk\ASIA_FLOW\*.out"
del "S:\FXO\batch\Daily_Risk\ASIA_GENIE\*.out"
del "S:\FXO\batch\Daily_Risk\ASIA_SPG\*.out"
del "S:\FXO\batch\Daily_Risk\BRAZIL_FX\*.out"
del "S:\FXO\batch\Daily_Risk\C4\*.out"
del "S:\FXO\batch\Daily_Risk\COMPLEX\*.out"
del "S:\FXO\batch\Daily_Risk\CROSSES\*.out"
del "S:\FXO\batch\Daily_Risk\EMEA_CPX\*.out"
del "S:\FXO\batch\Daily_Risk\EMEA_FLOW\*.out"
del "S:\FXO\batch\Daily_Risk\FX_PROP\*.out"
del "S:\FXO\batch\Daily_Risk\G5\*.out"
del "S:\FXO\batch\Daily_Risk\GENEVA\*.out"
del "S:\FXO\batch\Daily_Risk\INACTIVE\*.out"
del "S:\FXO\batch\Daily_Risk\LTM_GCO\*.out"
del "S:\FXO\batch\Daily_Risk\LTM_GXO\*.out"
del "S:\FXO\batch\Daily_Risk\LTM_RC\*.out"
del "S:\FXO\batch\Daily_Risk\MAN\*.out"
del "S:\FXO\batch\Daily_Risk\OTHER\*.out"
del "S:\FXO\batch\Daily_Risk\RETAIL\*.out"
del "S:\FXO\batch\Daily_Risk\SPOT\*.out"

rem Limits Directories - One Per Group

MkDir "S:\FXO\batch\Limits\EMK_ASIA\"
MkDir "S:\FXO\batch\Limits\EMK_EURO\"
MkDir "S:\FXO\batch\Limits\FX_PROP\"
MkDir "S:\FXO\batch\Limits\G11\"
MkDir "S:\FXO\batch\Limits\GENEVA\"
MkDir "S:\FXO\batch\Limits\INACTIVE\"
MkDir "S:\FXO\batch\Limits\LATAMS\"
MkDir "S:\FXO\batch\Limits\LTM_FX\"
MkDir "S:\FXO\batch\Limits\MAN\"
MkDir "S:\FXO\batch\Limits\OTHER\"
MkDir "S:\FXO\batch\Limits\SPOT\"
del "S:\FXO\batch\Limits\EMK_ASIA\Daily.out"
del "S:\FXO\batch\Limits\EMK_EURO\Daily.out"
del "S:\FXO\batch\Limits\FX_PROP\Daily.out"
del "S:\FXO\batch\Limits\G11\Daily.out"
del "S:\FXO\batch\Limits\GENEVA\Daily.out"
del "S:\FXO\batch\Limits\INACTIVE\Daily.out"
del "S:\FXO\batch\Limits\LATAMS\Daily.out"
del "S:\FXO\batch\Limits\LTM_FX\Daily.out"
del "S:\FXO\batch\Limits\MAN\Daily.out"
del "S:\FXO\batch\Limits\OTHER\Daily.out"
del "S:\FXO\batch\Limits\SPOT\Daily.out"

rem Copy Latest Market Data For Soho Revaluation - Assume Local Path Is used ********

copy "\\lons000752\fxoglobal\SOHO\runtime\data\map\rates\management\*.*" "S:\USERS\S_McHugh\Soho\Runtime\data\map\rates\"
copy "\\lons000752\fxoglobal\SOHO\runtime\data\sched\dateschd\*.*" "S:\USERS\S_McHugh\Soho\Runtime\data\sched\dateschd\"
copy "\\lons000752\fxoglobal\SOHO\runtime\data\sched\fixings\*.*" "S:\USERS\S_McHugh\Soho\Runtime\data\sched\fixings\"

rem Copy Market Data's Date File That We Use For Soho Revaluation ********
copy "\\lons000752\fxoglobal\SOHO\runtime\data\map\rates\management\date.dat" "S:\FXO\batch\"

rem Run the Risk For All Portfolios On Each Book********
del "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out"
"\\lons000752\fxoglobal\Soho\Release\Soho\10.40\soho.exe" /database=fxoldb::fxoliv /batch=RA_ASIA_FLOW /batchrevalset=Management 
copy "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out" "S:\FXO\batch\Daily_Risk\ASIA_FLOW\"

del "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out"
"\\lons000752\fxoglobal\Soho\Release\Soho\10.40\soho.exe" /database=fxoldb::fxoliv /batch=RA_ASIA_GENIE /batchrevalset=Management 
copy "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out" "S:\FXO\batch\Daily_Risk\ASIA_GENIE\"

del "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out"
"\\lons000752\fxoglobal\Soho\Release\Soho\10.40\soho.exe" /database=fxoldb::fxoliv /batch=RA_ASIA_SPG /batchrevalset=Management 
copy "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out" "S:\FXO\batch\Daily_Risk\ASIA_SPG\"

del "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out"
"\\lons000752\fxoglobal\Soho\Release\Soho\10.40\soho.exe" /database=fxoldb::fxoliv /batch=RA_BRAZIL_FX /batchrevalset=Management 
copy "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out" "S:\FXO\batch\Daily_Risk\BRAZIL_FX\"

del "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out"
"\\lons000752\fxoglobal\Soho\Release\Soho\10.40\soho.exe" /database=fxoldb::fxoliv /batch=RA_C4 /batchrevalset=Management 
copy "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out" "S:\FXO\batch\Daily_Risk\C4\"

del "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out"
"\\lons000752\fxoglobal\Soho\Release\Soho\10.40\soho.exe" /database=fxoldb::fxoliv /batch=RA_COMPLEX /batchrevalset=Management 
copy "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out" "S:\FXO\batch\Daily_Risk\COMPLEX\"

del "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out"
"\\lons000752\fxoglobal\Soho\Release\Soho\10.40\soho.exe" /database=fxoldb::fxoliv /batch=RA_CROSSES /batchrevalset=Management 
copy "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out" "S:\FXO\batch\Daily_Risk\CROSSES\"

del "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out"
"\\lons000752\fxoglobal\Soho\Release\Soho\10.40\soho.exe" /database=fxoldb::fxoliv /batch=RA_EMEA_CPX /batchrevalset=Management 
copy "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out" "S:\FXO\batch\Daily_Risk\EMEA_CPX\"

del "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out"
"\\lons000752\fxoglobal\Soho\Release\Soho\10.40\soho.exe" /database=fxoldb::fxoliv /batch=RA_EMEA_FLOW /batchrevalset=Management 
copy "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out" "S:\FXO\batch\Daily_Risk\EMEA_FLOW\"

del "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out"
"\\lons000752\fxoglobal\Soho\Release\Soho\10.40\soho.exe" /database=fxoldb::fxoliv /batch=RA_FX_PROP /batchrevalset=Management 
copy "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out" "S:\FXO\batch\Daily_Risk\FX_PROP\"

del "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out"
"\\lons000752\fxoglobal\Soho\Release\Soho\10.40\soho.exe" /database=fxoldb::fxoliv /batch=RA_G5 /batchrevalset=Management 
copy "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out" "S:\FXO\batch\Daily_Risk\G5\"

del "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out"
"\\lons000752\fxoglobal\Soho\Release\Soho\10.40\soho.exe" /database=fxoldb::fxoliv /batch=RA_GENEVA /batchrevalset=Management 
copy "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out" "S:\FXO\batch\Daily_Risk\GENEVA\"

del "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out"
"\\lons000752\fxoglobal\Soho\Release\Soho\10.40\soho.exe" /database=fxoldb::fxoliv /batch=RA_INACTIVE /batchrevalset=Management 
copy "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out" "S:\FXO\batch\Daily_Risk\INACTIVE\"

del "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out"
"\\lons000752\fxoglobal\Soho\Release\Soho\10.40\soho.exe" /database=fxoldb::fxoliv /batch=RA_LTM_GCO /batchrevalset=Management 
copy "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out" "S:\FXO\batch\Daily_Risk\LTM_GCO\"

del "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out"
"\\lons000752\fxoglobal\Soho\Release\Soho\10.40\soho.exe" /database=fxoldb::fxoliv /batch=RA_LTM_GXO /batchrevalset=Management 
copy "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out" "S:\FXO\batch\Daily_Risk\LTM_GXO\"

del "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out"
"\\lons000752\fxoglobal\Soho\Release\Soho\10.40\soho.exe" /database=fxoldb::fxoliv /batch=RA_LTM_RC /batchrevalset=Management 
copy "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out" "S:\FXO\batch\Daily_Risk\LTM_RC\"

del "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out"
"\\lons000752\fxoglobal\Soho\Release\Soho\10.40\soho.exe" /database=fxoldb::fxoliv /batch=RA_MAN /batchrevalset=Management 
copy "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out" "S:\FXO\batch\Daily_Risk\MAN\"

del "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out"
"\\lons000752\fxoglobal\Soho\Release\Soho\10.40\soho.exe" /database=fxoldb::fxoliv /batch=RA_OTHER /batchrevalset=Management 
copy "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out" "S:\FXO\batch\Daily_Risk\OTHER\"

del "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out"
"\\lons000752\fxoglobal\Soho\Release\Soho\10.40\soho.exe" /database=fxoldb::fxoliv /batch=RA_RETAIL /batchrevalset=Management 
copy "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out" "S:\FXO\batch\Daily_Risk\RETAIL\"

del "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out"
"\\lons000752\fxoglobal\Soho\Release\Soho\10.40\soho.exe" /database=fxoldb::fxoliv /batch=RA_SPOT /batchrevalset=Management 
copy "S:\USERS\S_McHugh\Soho\Runtime\data\reports\possums\*.out" "S:\FXO\batch\Daily_Risk\SPOT\"


rem Daily Limits File ********

del "S:\USERS\S_McHugh\Soho\Runtime\data\reports\spottnrs\*.out"
"\\lons000752\fxoglobal\Soho\Release\Soho\10.40\soho.exe" /database=fxoldb::fxoliv /batch=RB_EMK_ASIA /batchrevalset=Management 
copy "S:\USERS\S_McHugh\Soho\Runtime\data\reports\spottnrs\*.out" "S:\FXO\batch\Limits\EMK_ASIA\Daily.out"

del "S:\USERS\S_McHugh\Soho\Runtime\data\reports\spottnrs\*.out"
"\\lons000752\fxoglobal\Soho\Release\Soho\10.40\soho.exe" /database=fxoldb::fxoliv /batch=RB_EMK_EURO /batchrevalset=Management 
copy "S:\USERS\S_McHugh\Soho\Runtime\data\reports\spottnrs\*.out" "S:\FXO\batch\Limits\EMK_EURO\Daily.out"

del "S:\USERS\S_McHugh\Soho\Runtime\data\reports\spottnrs\*.out"
"\\lons000752\fxoglobal\Soho\Release\Soho\10.40\soho.exe" /database=fxoldb::fxoliv /batch=RB_FX_PROP /batchrevalset=Management 
copy "S:\USERS\S_McHugh\Soho\Runtime\data\reports\spottnrs\*.out" "S:\FXO\batch\Limits\FX_PROP\Daily.out"

del "S:\USERS\S_McHugh\Soho\Runtime\data\reports\spottnrs\*.out"
"\\lons000752\fxoglobal\Soho\Release\Soho\10.40\soho.exe" /database=fxoldb::fxoliv /batch=RB_G11 /batchrevalset=Management 
copy "S:\USERS\S_McHugh\Soho\Runtime\data\reports\spottnrs\*.out" "S:\FXO\batch\Limits\G11\Daily.out"

del "S:\USERS\S_McHugh\Soho\Runtime\data\reports\spottnrs\*.out"
"\\lons000752\fxoglobal\Soho\Release\Soho\10.40\soho.exe" /database=fxoldb::fxoliv /batch=RB_GENEVA /batchrevalset=Management 
copy "S:\USERS\S_McHugh\Soho\Runtime\data\reports\spottnrs\*.out" "S:\FXO\batch\Limits\GENEVA\Daily.out"

del "S:\USERS\S_McHugh\Soho\Runtime\data\reports\spottnrs\*.out"
"\\lons000752\fxoglobal\Soho\Release\Soho\10.40\soho.exe" /database=fxoldb::fxoliv /batch=RB_INACTIVE /batchrevalset=Management 
copy "S:\USERS\S_McHugh\Soho\Runtime\data\reports\spottnrs\*.out" "S:\FXO\batch\Limits\INACTIVE\Daily.out"

del "S:\USERS\S_McHugh\Soho\Runtime\data\reports\spottnrs\*.out"
"\\lons000752\fxoglobal\Soho\Release\Soho\10.40\soho.exe" /database=fxoldb::fxoliv /batch=RB_LATAMS /batchrevalset=Management 
copy "S:\USERS\S_McHugh\Soho\Runtime\data\reports\spottnrs\*.out" "S:\FXO\batch\Limits\LATAMS\Daily.out"

del "S:\USERS\S_McHugh\Soho\Runtime\data\reports\spottnrs\*.out"
"\\lons000752\fxoglobal\Soho\Release\Soho\10.40\soho.exe" /database=fxoldb::fxoliv /batch=RB_LTM_FX /batchrevalset=Management 
copy "S:\USERS\S_McHugh\Soho\Runtime\data\reports\spottnrs\*.out" "S:\FXO\batch\Limits\LTM_FX\Daily.out"

del "S:\USERS\S_McHugh\Soho\Runtime\data\reports\spottnrs\*.out"
"\\lons000752\fxoglobal\Soho\Release\Soho\10.40\soho.exe" /database=fxoldb::fxoliv /batch=RB_MAN /batchrevalset=Management 
copy "S:\USERS\S_McHugh\Soho\Runtime\data\reports\spottnrs\*.out" "S:\FXO\batch\Limits\MAN\Daily.out"

del "S:\USERS\S_McHugh\Soho\Runtime\data\reports\spottnrs\*.out"
"\\lons000752\fxoglobal\Soho\Release\Soho\10.40\soho.exe" /database=fxoldb::fxoliv /batch=RB_OTHER /batchrevalset=Management 
copy "S:\USERS\S_McHugh\Soho\Runtime\data\reports\spottnrs\*.out" "S:\FXO\batch\Limits\OTHER\Daily.out"

del "S:\USERS\S_McHugh\Soho\Runtime\data\reports\spottnrs\*.out"
"\\lons000752\fxoglobal\Soho\Release\Soho\10.40\soho.exe" /database=fxoldb::fxoliv /batch=RB_SPOT /batchrevalset=Management 
copy "S:\USERS\S_McHugh\Soho\Runtime\data\reports\spottnrs\*.out" "S:\FXO\batch\Limits\SPOT\Daily.out"

________
BUY SILVERSURFER VAPORIZER

Post by **Marcus Tettmar** » Wed Jun 07, 2006 5:42 pm

Hi,

Are you sure you don't have more than one instance of Macro Scheduler running?

In any case there have been some improvements to the scheduler since version 7.3. A quick scan of the history list shows:

Version 7.3.02 24/11/2004
Improved simultaneous starting of macros scheduled for same start time
Fixed problems which could occur with schedules of repeating macros on startup

These may not appear to have any relevance at first but the fact is you do have an out of date version. You can upgrade to 7.4.009 for free. So before we spend too much time trying to debug an issue with an old version it would be sensible if you can upgrade to 7.4.009 first (or, if you are concerned about upgrading, at least install a separate copy of it and set up your schedule within it). You can download this at the registered user download area:

http://www.mjtnet.com/dldregd.htm

Any problems please contact support:
http://www.mjtnet.com/contact.htm

We should at least first check that the issue is fixed in the latest 7.x release and take it from there if not.

swilliams · Post by **swilliams** » Wed Jun 07, 2006 5:51 pm

Marcus,
I will take your advice. Unfortunately it will take some time to see whether it works (The security processes here won't allow a download to the users machines so I have to work around it). I will let you know how it goes,
Thank you
Sandra
________
EASY VAPE

Post by **Marcus Tettmar** » Wed Jun 07, 2006 6:40 pm

Can you not download and burn to a CDROM? Right click on the download and select Save Target As. Then burn that file to a CDROM or copy across the network to the target machine.

JRL · Post by **JRL** » Wed Jun 07, 2006 6:43 pm

Sandra,

I agree with Marcus. I'm not big on updates with most software but Macro Scheduler updates are always worthwhile. If you are able to upgrade for free you absolutely should do that for all of your users. If the upgrade resolves your problem that will be great. On the other hand if the upgrade does not resolve the problem I'd still like to see your Macro Scheduler script. What you posted appears to me to be the DOS batch file. I see the batch file as the least likely source of your repeat problem. Looking at the posted text I see nothing that might cause your problem.

Let us know if the upgrade helps.
Later,
Dick

swilliams · Post by **swilliams** » Thu Jun 08, 2006 8:51 am

I'd misunderstood the 'script'. It's just
Executefile> S:\FXO\Batch\RM_APPL_DAILYRISK_REMOTE_EX_GENIE.BAT
I will get the upgrade - but once you're in a large organisation nothing is that simple - it will cost thousands and probably take weeks before I can package the upgrade so that it can be put on user's macines. I'll let you know how it goes,
Sandra
________
Buy Mflb

Post by **Marcus Tettmar** » Thu Jun 08, 2006 9:12 am

Cost thousands? All I am suggesting is that you first try the updated version in a controlled environment so that we can ascertain whether or not the issue you are experiencing is something that has already been fixed. As it doesn't appear to be a scripting issue and unless you have multiple instances running, or there is something about your script we don't yet know, my hunch at this stage is that this is a bug that has already been resolved. The update is free and it should take no more than 5 minutes to test my theory.