Re: Jobs Failed do not work when scheduled done via DTS Scheduled Package

From: Steen Persson (SPE_at_REMOVEdatea.dk)
Date: 01/17/05 

Date: Mon, 17 Jan 2005 11:10:47 +0100

Are you running the job from Enterprise Manager/QA on you local PC or via
EM/QA directly on the server (e.g. via RemoteDesktop)? Depending on the job
steps you are running it might fail if you try to run it from your local
machine -e.g if it involves any files or filepaths that is "known" by the
server, but not by your local machine.

Regards
Steen

dmc wrote:
> Hi there,
>
> We found this problem a little odd, jobs that were created using DTS'
> Scheduled Package FAILS all the time but if we create a new job
> manually and use TSQL under steps it WORKS.
>
> Anything that was done via DTS' FAILS.
>
> here is a typical error that we get:
>
> The process could not be created for step 1 of job
> 0x52C39FD0D0DE644E8750519DD6824E94 (reason: The system cannot find
> the file specified). The step failed.
>
> the account that is logged on is a domain account and we even made it
> a dbo. the sql is set to use either sql or windows authentication.
>
> It really looks like the Jobs are failing because the dtsrun doesn't
> know where to find the file involved. Could be the SQL path got
> screwed up or something? Do we need to check variable settings?
>
> Any comments or suggestions is much appreciated.
>
> TIA
> dmc

Relevant Pages

  • RE: 0x80004005 - you need permission to view its data
    ... Based on the information in the "Security Account Delegation" topic in SQL ... When connecting to multiple servers, and with each server change, we need ... Establish a SPN for your domain account which will enable Kerberos ...
    (microsoft.public.sqlserver.security)
  • Re: ISP scenario for AD and DNS
    ... WSS needs a domain account to connect with a non-local SQL ... non-local SQL Server, so it has to be a member of a domain. ... Exchange does require Active Directory, but if your thinking of Exchange ...
    (microsoft.public.windows.server.dns)
  • Re: Security
    ... by running a job and my domain account which is also ... SA on both SQL servers by using exec xp_cmdshell 'dtsrun'. ... in the dts package connection is a SQL Login that is SA on the server it is ... >> connection to the other server uses to sysadmin. ...
    (microsoft.public.sqlserver.server)
  • Re: Error 22042
    ... Itīs member of Domain Admins group, ... configured it as the account for SQL Service and SQL ... Server Agent in another server in the same domain with no ... >> Everytime I try to configure a domain account for SQL ...
    (microsoft.public.sqlserver.security)
  • Re: Catch22
    ... The SQL installation fails at the server configuration. ... present and SP3 will not install because it doesn't find the server. ...
    (microsoft.public.sqlserver.server)