April 11, 2003 at 8:37 am
I am attempting to schedule a DTS package (SQL Server 7.0) that connects to an AS400 database, using a system DSN to Client Access, which is installed on the server. When I execute the package directly it runs fine, but when I execute the job (either directly or scheduled) it hangs indefinitely (never completing until I manually stop it). I have discovered that I can get it to work if I log onto the server directly using the same account that starts the SQLAgentService. While the server has that user logged in I am able to execute the job, even if I run it remotely from Enterprise Manager on my desktop. But when there is no user logged into the server, the job hangs. I would prefer not to have to have the user logged into the server to make this work. Does anyone have any insight into this? Thanks,
Andrew
Edited by - amackay_1 on 04/11/2003 08:38:51 AM
April 11, 2003 at 8:47 am
Do you send SQL Mail in your DTS package?
April 11, 2003 at 8:56 am
Actually, I have 2 different jobs I'm testing.. one sends SQL mail, the other doesn't. Both fail in the manner I described.
Edited by - amackay_1 on 04/11/2003 08:59:26 AM
April 11, 2003 at 9:23 am
Can you check who is owner of the DTS job? Try change it to SQL Server Agent account.
April 11, 2003 at 10:00 am
Yes, the owner of the job is already the same as the SQL Server Agent startup account.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply