Hi experts...

I'm trying to schedule a DTS package (import some tables
from Mysql database) but there is
an error and I don't know how to resolve it.

The error is always the same...
"The job failed. The Job was invoked by Schedule 24
(Import RT data). The last step to run was step 1 (Import
RT data)."

I have tried changing the all the parameters in the job
properties, but I always obtein the same message.

The DTS package works fine, I can execute and it works,
the problem is the schedule...

Thanks in advanced...

When you run the package manually, it executes under your
security context and from your PC. When you schedule it as a
job, it runs from the server and under the security context
of the service account for SQL Agent (usually...depends on
job owner and some other things).
You can find more info in the following article:
INF: How to Run a DTS Package as a Scheduled Job
http://support.microsoft.com/?kbid=269074

-Sue

On Tue, 5 Oct 2004 06:59:29 -0700, "newboy"
<anonymous (AT) discussions (DOT) microsoft.com> wrote: