Home > Archive > MS SQL Server DTS > September 2005 > Jobs not running









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Jobs not running
A.B.

2005-09-22, 1:23 pm

I have some jobs that just started failing. They were working fine and then
they just stopped. Nothing was changed. This has happened before and then
they just started working again. Can anybody tell me why this happens. The
jobs execute DTS packages that import data from text files and other
databases. The DTS packages work fine when run on their own. It is just when
I try to run them as a scheduled job they fail.
Allan Mitchell

2005-09-22, 1:23 pm

Usually the answer can be found here

http://support.microsoft.com/?kbid=269074



"A.B." <AB@discussions.microsoft.com> wrote in message
news:CD767D85-4586-4B4F-88A4- 5F4B763119D2@microso
ft.com:

> I have some jobs that just started failing. They were working fine and
> then
> they just stopped. Nothing was changed. This has happened before and
> then
> they just started working again. Can anybody tell me why this happens.
> The
> jobs execute DTS packages that import data from text files and other
> databases. The DTS packages work fine when run on their own. It is just
> when
> I try to run them as a scheduled job they fail.

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com