Hallo to all,
I hope the SQL and DTS experts can help me.
I have problems with sheduling a small script copy data from Sql2000
to a flat txt-file.
When executing it in SEM on a different PC it works fine
when sheduling it on the sql server it fails with error 208.
I read a lot about this in the news group and thought the
SQLSERVERAGENT has missing rights.
I granted SA Permission to the services MSSQLSERVER and SQLSERVERAGENT
( with local system account = has admin rights )
I logged in on the server with also SA rights.
I got everytime the same error.
What should I do to allow SQLSERVERAGENT to execute the job.
Many thanks in advance

Ralf

Are you copying the data to a text file on another server?
In that case, you can't have SQL Agent running under local
system as that account does not have network access - you
would need to use a domain account.
You can find troubleshooting steps for problems when a
package doesn't run when scheduled in the following:
INF: How to Run a DTS Package as a Scheduled Job
http://support.microsoft.com/?id=269074

-Sue

On 7 Apr 2004 04:31:28 -0700, kralemann.r (AT) bex (DOT) battenfeld.com
(ralle) wrote:

Hallo Sue ,
thanks for your reply.
The textfile is located on the same server.
Have you got another idea
Ralf

Sue Hoegemeier <Sue_H (AT) nomail (DOT) please> wrote

It depends on what you mean by error 208. If it's a SQL
error, that's the error number for invalid object name. If
it's a Windows event id 208, that's the warning for a job
failure. Without more information, it's hard to say. You
need to check the details for the job to get more
information on the failure. If you check job details, you
should be able to find more information.

-Sue

On 7 Apr 2004 21:46:17 -0700, kralemann.r (AT) bex (DOT) battenfeld.com
(ralle) wrote: