Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 DTS Problem

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-08-14 : 13:30:58
Minesh writes "I have designed a DTS for executing program in AS400 (AS400 Program) and than pulling data to SQL Server which processes the data and than sends back to AS400.
My problem is when i execute the DTS manually everything is working fine but when i schedule the DTS it is not working. My job status shows "executing..." and i do not receive any error but the active job status in AS400 does not list my job as well as i found that the AS400 program is also not executing.
So my question is why when i run manually everything is working very nice and when i schedule it is not ? Any suggestion is highly appreciated.
Thanks in advance for any help.

Minesh."
   

- Advertisement -