DTS jobs hang

Hi Experts out there,
I would like to know find out from you, I created a package in SQL 2000 DTS
module. When i execute the package it runs perfectly well. Unfortunately when
I execute it by scheduling, the package will hang there. The status is always
"Executing...step (1)...". Perhaps when I execute manually, it takes less
than 30 seconds to complete...but when I schedule it, it just hang there for
many minutes and it doesn't continue..There is no error message prompt at all.
Can some one please give me some tips on how should I go about scheduling
the package and run successfully.. Many Thanks in advance...
Regards,
Rachael Lim
When you say you run it manually, how do you do this? Where and how are you
logged in? Do you run the job manually or do you load and execute the DTS
package manually?
Sincerely,
Anthony Thomas

"Rachael Lim" <Rachael Lim@.discussions.microsoft.com> wrote in message
news:BB8EB37D-25C1-4F8B-BF87-D5263131B9ED@.microsoft.com...
Hi Experts out there,
I would like to know find out from you, I created a package in SQL 2000 DTS
module. When i execute the package it runs perfectly well. Unfortunately
when
I execute it by scheduling, the package will hang there. The status is
always
"Executing...step (1)...". Perhaps when I execute manually, it takes less
than 30 seconds to complete...but when I schedule it, it just hang there for
many minutes and it doesn't continue..There is no error message prompt at
all.
Can some one please give me some tips on how should I go about scheduling
the package and run successfully.. Many Thanks in advance...
Regards,
Rachael Lim
|||WHen I execute it manually means I am in the design mode of the package and
execute the package.
I created the scheduled job by right-clicing on the package and select
schedule package.
"AnthonyThomas" wrote:

> When you say you run it manually, how do you do this? Where and how are you
> logged in? Do you run the job manually or do you load and execute the DTS
> package manually?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Rachael Lim" <Rachael Lim@.discussions.microsoft.com> wrote in message
> news:BB8EB37D-25C1-4F8B-BF87-D5263131B9ED@.microsoft.com...
> Hi Experts out there,
> I would like to know find out from you, I created a package in SQL 2000 DTS
> module. When i execute the package it runs perfectly well. Unfortunately
> when
> I execute it by scheduling, the package will hang there. The status is
> always
> "Executing...step (1)...". Perhaps when I execute manually, it takes less
> than 30 seconds to complete...but when I schedule it, it just hang there for
> many minutes and it doesn't continue..There is no error message prompt at
> all.
> Can some one please give me some tips on how should I go about scheduling
> the package and run successfully.. Many Thanks in advance...
> Regards,
> Rachael Lim
>
>
|||Enable package level logging and rerun from the scheduled job. If you have
to cancel the job, that's ok. The logging happens at each step within the
package. This will give you more verbose execution state information.
I suspect you have a permissions issue but the logging should help you
determine this.
Keep in mind that the package runs under the permissions of the executor,
not the storage location and from the location of the executor. When you
run, your permissions and your workstation, when the SQL Agent job runs, the
service account that the SQL Agent is running under and from the SS server's
location. This is an important consideration for local drives and maps as
well as installed executibles, like the WSH ActiveX components.
Sincerely,
Anthony Thomas

"Rachael Lim" <RachaelLim@.discussions.microsoft.com> wrote in message
news:95D6E3CD-EDD7-4D01-88AE-213BCE343C7F@.microsoft.com...
WHen I execute it manually means I am in the design mode of the package and
execute the package.
I created the scheduled job by right-clicing on the package and select
schedule package.
"AnthonyThomas" wrote:

> When you say you run it manually, how do you do this? Where and how are
you
> logged in? Do you run the job manually or do you load and execute the DTS
> package manually?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Rachael Lim" <Rachael Lim@.discussions.microsoft.com> wrote in message
> news:BB8EB37D-25C1-4F8B-BF87-D5263131B9ED@.microsoft.com...
> Hi Experts out there,
> I would like to know find out from you, I created a package in SQL 2000
DTS
> module. When i execute the package it runs perfectly well. Unfortunately
> when
> I execute it by scheduling, the package will hang there. The status is
> always
> "Executing...step (1)...". Perhaps when I execute manually, it takes less
> than 30 seconds to complete...but when I schedule it, it just hang there
for
> many minutes and it doesn't continue..There is no error message prompt at
> all.
> Can some one please give me some tips on how should I go about scheduling
> the package and run successfully.. Many Thanks in advance...
> Regards,
> Rachael Lim
>
>