I have a DTS job that is scheduled to run once a day at 5PM. The job
invokes a couple of batch files which in turn execute a java application
and periodically I am seeing from the logs that the job appears to be
executed multiple times on the same day -- usually within a couples of
seconds (or less) of each other and always on or around the 5PM
scheduled time (i.e., 5:00:00PM, then between 5:00:01PM and 5:00:04 PM).
I imnitially though that it may have been a bug in the java process
but after placing detailed messages in the top level batch file, it can
be clearly seen that the batch files is invoked more than once.

Has anyone seen/ experienced similar behaviour or can anyone suggest a
method of looking into the DTS system to see what might cause this
behaviour.

-dermot grady

This may be a stretch, but look at the jobs in SQL Server Agent in
Enterprise Manager and see if for some reason there are multiple entries
for this DTS package. The package itself would not do this, but the
sceduling of the job may be a problem.

Rsnd
This posting is provided "as is" with no warranties and confers no rights.

Rand Boyd [MSFT] wrote:
were created and I was able to clean it up through SQL-Server Agent.
Time will now tell.

thanks.

dermot