Timing Schedule

[cjvoss]

Bare with me, I just started using the program so I am going to describe the problem to the best of my ability. I have multiple macros set up to run the same macro at different times for redundancy(so all of the work doesnt have to be redone manually) . Out of the blue one of the macros just quit working properly. The other macros (exactly the same) continue to run properly at their assigned times. I've recreated the macro and tried to run it in a similar time slot, but to no avail. Shutting down the automation is not an option either, everything is time sensitive. Anyone have any ideas to fix this problem with out shutting down macro scheduler? I am assuming its a probelm with macro scheduler for the same reason that it continues to work with the other macros I have set up. I know I am kinda tying hands with out being able to shutdown, restart or uninstall, reinstall. But I would love to hear any ideas...Thanks!

[Bob Hansen]

Have you run a log file and looked in that for clues?

Are other activities running while the macro is running?

We probably need to see the macros to come up with good answers for you.

[cjvoss]

Here is the macrco that is working:
'==================================================='
'OTIS_1_Minute (REVISED: 02/07/04 7:00am)'
'==================================================='
'If the data set U:\hourord.txt '
'exists then run Access OTIS_1_Minute.mdb '
'If not, just end this macro '

'==================================================='
'STEP #1: TEST FOR THE PRESENCE OF THE DATA FILE'
'==================================================='
IfFileExists>U:\hourord.txt,STEP2
goto>END

'==================================================='
'STEP #2: RUN ImportData.mbd'
'NOTE---Date and Time fields are not imported'
'==================================================='
Label>STEP2
Let>PATH=C:\Program Files\Microsoft Office 2000\Office\MSACCESS.EXE
Concat>PATH, X:\PROD_SYS\Applications\New_OTIS_FRONT\OTIS_1_Minute.mdb
Run Program>PATH
waitready>0
Wait>10

'==================================================='
'STEP #3: DELETE THE EXISTING DATA FILE'
'==================================================='
Label>STEP3
DeleteFile>U:\hourord.txt
goto>END

Label>END
'==================================================='
'END OTIS_1_MINUTE (REVISED: 02/07/04 7:00am)'
'==================================================='


Here is the one that quit working:
'==================================================='
'OTIS_1_Minute (REVISED: 02/07/04 7:00am)'
'==================================================='
'If the data set U:\hourord.txt '
'exists then run Access OTIS_1_Minute.mdb '
'If not, just end this macro '

'==================================================='
'STEP #1: TEST FOR THE PRESENCE OF THE DATA FILE'
'==================================================='
IfFileExists>U:\hourord.txt,STEP2
goto>END

'==================================================='
'STEP #2: RUN ImportData.mbd'
'NOTE---Date and Time fields are not imported'
'==================================================='
Label>STEP2
Let>PATH=C:\Program Files\Microsoft Office 2000\Office\MSACCESS.EXE
Concat>PATH, X:\PROD_SYS\Applications\New_OTIS_FRONT\OTIS_1_Minute.mdb
Run Program>PATH
waitready>0
Wait>10

'==================================================='
'STEP #3: DELETE THE EXISTING DATA FILE'
'==================================================='
Label>STEP3
DeleteFile>U:\hourord.txt
goto>END

Label>END
'==================================================='
'END OTIS_1_MINUTE (REVISED: 02/07/04 7:00am)'
'==================================================='

[Marcus Tettmar]

What does the log file show for the macro that is failing? What is different about the environment at the time the failing macro is scheduled - any screen savers? Windows locked/logged out? Any network shares disconnected at that time? Etc.