dts fails when run as scheduled job

#1

We have a dts that has been running for months. Now it won't run - it doesn't
even start. Nothing in the logs. And if we try and create a new job from the
package, it won't run either. We can't even run it manually.

Also when we create a new dts that runs fine when executed as a dts, it
won't run as a job. The time never shows up in the "next run date" column and
it doesn't run. However, we have other jobs that run every half hour or hour
throughout the day and they are still running.

Any ideas?

Thanks,
--
Dan D.

#2

As a first guess, I'd look into whether the security settings that the
job runs under have been changed.

Dan D. wrote:

Quote:

We have a dts that has been running for months. Now it won't run - it doesn't
even start. Nothing in the logs. And if we try and create a new job from the
package, it won't run either. We can't even run it manually.

Also when we create a new dts that runs fine when executed as a dts, it
won't run as a job. The time never shows up in the "next run date" column and
it doesn't run. However, we have other jobs that run every half hour or hour
throughout the day and they are still running.

Any ideas?

Thanks,

#3

They haven't. I'm going to apply SP3a this weekend and see if that helps.
Thanks.

"Cagey" wrote:

Quote:

As a first guess, I'd look into whether the security settings that the
job runs under have been changed.

Dan D. wrote:
We have a dts that has been running for months. Now it won't run - it doesn't
even start. Nothing in the logs. And if we try and create a new job from the
package, it won't run either. We can't even run it manually.

Also when we create a new dts that runs fine when executed as a dts, it
won't run as a job. The time never shows up in the "next run date" column and
it doesn't run. However, we have other jobs that run every half hour or hour
throughout the day and they are still running.

Any ideas?

Thanks,

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

dts fails when run as scheduled job

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

dts fails when run as scheduled job - 01-12-2005 , 02:31 PM

Re: dts fails when run as scheduled job - 01-13-2005 , 03:19 AM

Re: dts fails when run as scheduled job - 01-14-2005 , 11:05 AM