Because, if the schedule runs overnoght, the message stops the batch file from ending. OK has to be clicked before the next part of the script can run.
Not sure how to suppress the messaging but may have a workaround if you can schedule the DTS package.
SO ... right click the DTS package and schedule the job.
Go to the Jobs folder under SQL Server Agent tab and set the scheduled job up so that it does NOT fire on a scheduled time.
Then in you batch file, is an osql command to start the job as in ...
Code:
osql -E -Q"exec msdb.dbo.sp_start_job 'jobname'
Maybe this may work but if you were waiting in your bat file for the DTSRun to terminate then move on I am not sure if this approach may fire off the job and immediatley return to the bat before the DTS job itself was complete.
Maybe you could add a delay/wait command if you know the DTS package runs under a predetermined time.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.