DTS-Jobs run intermittently

  • Hi all,

    I have a few DTS packages that import data from the file structure of our custom software...I have scheduled these DTS packages to run as jobs every 1hr...The jobs work most of the times but ocassionally when I check out on the status of these jobs I find that some jobs are just stuck...

    They dont show failed status..But their last run date is way back then expected...I have to stop the job and start it again to make it function properly...

    Is there any remedy for this...

    I will appreciate any help on this...

    Thanks

    Jol


    Kindest Regards,

    Joel

  • What are the error messages in the Windows Event Log for the time that the package did not run

    Regards,Yelena Varsha

  • What is the package doing (step-by-step), could be you are not getting a completion message from an object involved in the process. Had this happen with an earlier version of the Oracle Client (I believe it was an version 8 client but not sure off hand).

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply