job scheduled on SQL Agent - 03-23-2005 , 05:03 AM
We are trying to run a job scheduled on SQL Agent that has only 1 step. The
step is an Operating System Command of:
DTSRun /s <Server> /n NEW Email Team Managers /e
which attempts to run a DTS package. The DTS Package itself has only 1 step
which is an ActiveX Script Task. The task connects to a database, runs
through a few records and sends emails out.
Since moving this process to a new server, the job will not run via SQL
Server Agent. The history view of the step provides the following
"Executed as user: <Domain>\Services. DTSRun: Loading... Error:
-2147467259 (80004005); Provider Error: 17 (11) Error string:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied. Error source: Microsoft OLE DB Provider for SQL Server
Help file: Help context: 0. Process Exit Code 1. The step failed."
For info: We get the same if we use the command line with a username and
password (/u username and /p password rather than /e in the command line).
Also SQL Server Agent does run another DTS package that contains T-SQL and
Re: job scheduled on SQL Agent - 03-23-2005 , 02:46 PM
The /E and /S and /U just connect you to the SQL Server to be able to
retrieve the package nothing more.
Have a look at this article
"gogerc" <gogerc (AT) discussions (DOT) microsoft.com> wrote
RE: job scheduled on SQL Agent - 03-24-2005 , 04:23 AM
Thanks for the response Allen but we have seemed to fixed the issue now our
selves. But thanks for the Link in creating DTS Packages.