I am struggling with a problem where DTS packages are run overnight via scheduled jobs. However, the jobs appear to be 'hanging' with the status of 'executing', and so they fail to run the following night. The only (manual) solution we can find atvpresent is to pretend to edit the job from the Management Console at which point its status is refreshed. HELP!!

--
Aaron
WMCG

Do you have any debug code issuing MSGBOX ??

"Aaron" <Aaron (AT) discussions (DOT) microsoft.com> wrote

'executing', and so they fail to run the following night. The only (manual)
solution we can find atvpresent is to pretend to edit the job from the
Management Console at which point its status is refreshed. HELP!!

Paul

I'm really sorry, but I don't have a clue what you are talking about!!! If you could tell me in layman's terms what to look for and send, then I will do it.

Thanks for your help


Aaron
--
Aaron
WMCG


"Paul Smith" wrote:

I think what Paul means is

"Do you have any msgbox statements in your job scripts?"

Regards

Partha Mandayam
Software Consultant
Home page: http://partha.tripod.com


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Partha & Paul

Sorry, I understand the question now!

There are no message box statements in the job scripts. The job script executes a stored procedure which in turn (after a few audit steps) runs the DTS package by executing a dtsrun command.

Any help gratefully received. Perhaps I am doing things completely wrong.

Thanks

Aaron


--
Aaron
WMCG


"Partha Mandayam" wrote: