Chore Splitting
Posted: Thu Mar 01, 2012 4:44 pm
I have a chore with a lot of processes that controls a daily data load and dimension maintenance tasks etc. This chore has been running successfully for quite some time until today. Yesterday I added a process that emails people when their password is about to expire using the following line of code in the data section of a TI process.
ExecuteCommand(sCmdLine, 0);
Where the command line calls a BAT file which in turn calls a VBS. This is all fairly standard practice which to be honest I cribbed from this and other forums.
I placed this process fairly near the beginning of the chore and what I noticed was that for every email generated a separate execution of all of the remaining processes in the chore took place! Has anyone seen anything like this behaviour?
ExecuteCommand(sCmdLine, 0);
Where the command line calls a BAT file which in turn calls a VBS. This is all fairly standard practice which to be honest I cribbed from this and other forums.
I placed this process fairly near the beginning of the chore and what I noticed was that for every email generated a separate execution of all of the remaining processes in the chore took place! Has anyone seen anything like this behaviour?