I worked with a person who liked to do things his way. He had to run an end of month report every month and it took 8 hours. There was lots of data from many sources. I looked at his code, modified it in our test environment, and it ran in under 90 minutes. He verified what I had suggested and the savings of time. He stated, “I will do it my way”! So the report took 8 hours to run.


>>Interestingly, I ran the process from the command window against Network database and the result is fine:
>>
>>

>>08/09/2006 01:17:05 PM Started to run Client Status Update process
>>08/09/2006 01:17:18 PM Started to commit changes...
>>08/09/2006 01:17:18 PM Committed all changes...
>>08/09/2006 01:17:18 PM Finished to run Client Status Update

>>
>>Why did the process run 2h. from Batch Service? I'll try another test.
>
>The new test finished in less than a minute. Something went awry in my previous test.