Posted by mati on 02/24/06 09:21

Hi

I've got 2 jobs and a problem with one of them. Both jobs import data from
..dbf tables into sql server, the working one copies 4 tables, the second
copies over 10 tables and it suspends to infinity when it's run as a job in
SQL Server Agent. The problem occured few weeks ago when we re-installed
Windows, SQL-Server etc. on server. For more information - DTS runs "from
hand" very vell, also, sometimes it works fine when run as a job (on average
once a week). What may be the reason?

thanks

• Next in forum: Re: long SQL lines for osql
• Prev in forum: Webserver request invalid query
• Thread view: scheduled dts suspends...

[Reply to this message]