I run a DTS job manually, it works fine woth no proble.
However, if I schedule it to run, it always fails
with the following message: ( in the Event Viewer )
Event Type: Warning
Description:
SQL Server Scheduled Job 'BackorderByItemReport'
(0x6C0FDB5A6F7B6149AB8565F9F349FDE4) - Status: Failed -
Invoked on: 2003-09-09 14:44:00 - Message: The job
failed. The Job was invoked by Schedule 2
(BackorderByItemReport). The last step to run was step 1
(BackorderByItemReport).
Since the message doesn't provide enough info, I have no
idea about what's wrong. BTW, I have set up the
SQLServerAgent service running as a network user who is
also a member of the Local System Admin Group.
Has anybody experienced this?
Thanx.
Y.J.Yanjie,
INF: How to Run a DTS Package as a Scheduled Job
http://support.microsoft.com/default.aspx?scid=kb;en-us;269074
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Yanjie Ren" <yren@.cc3.com> wrote in message
news:640d01c377aa$773abe30$a501280a@.phx.gbl...
> I run a DTS job manually, it works fine woth no proble.
> However, if I schedule it to run, it always fails
> with the following message: ( in the Event Viewer )
> Event Type: Warning
> Description:
> SQL Server Scheduled Job 'BackorderByItemReport'
> (0x6C0FDB5A6F7B6149AB8565F9F349FDE4) - Status: Failed -
> Invoked on: 2003-09-09 14:44:00 - Message: The job
> failed. The Job was invoked by Schedule 2
> (BackorderByItemReport). The last step to run was step 1
> (BackorderByItemReport).
> Since the message doesn't provide enough info, I have no
> idea about what's wrong. BTW, I have set up the
> SQLServerAgent service running as a network user who is
> also a member of the Local System Admin Group.
> Has anybody experienced this?
> Thanx.
> Y.J.
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment