Re: CmdExec DTS -- Fails

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 05/10/04 

Date: Mon, 10 May 2004 17:05:07 +0100

localsystem though has no rights or ability to leave the box. 

-- 
-- 
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"GG" <anonymous@discussions.microsoft.com> wrote in message
news:CB8B406A-90ED-4214-A79F-961AD3903983@microsoft.com...
> The error that appears in the application event log is the following:
>
> SQL Server Scheduled Job 'test' (0x0327299BE7DBFB4FAAA5393A97BEE004) -
Status: Failed - Invoked on: 2004-05-10 10:55:22 - Message: The job failed.
The Job was invoked by User sa.  The last step to run was step 1 (test vbs).
>
> As you can see the job is owned by sa.  SQLServerAgent service is run as
localsystem account, which should have permissions to run commands.  Both
files in question reside on the database server on the C:\ drive.  I don't
make any reads or writes to the database, I am strictly attempting to call a
file via the cmdexec.
>
> Since I am able to run a simple ping command successfully as a job, this
leads me to believe that there is some error in the way I am calling these
files from the job command prompt.
>
> Any insight on the syntax of the calls?
>
> Thank You
>
>      ----- Allan Mitchell wrote: -----
>
>      Just because it works for you doesn't mean it will work for a job.
>
>      You have any errors?
>
>      Have a read of this first
>
>      http://support.microsoft.com/?kbid=269074
>
>      -- 
>      -- 
>
>      Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
>      www.SQLDTS.com - The site for all your DTS needs.
>      I support PASS - the definitive, global community
>      for SQL Server professionals - http://www.sqlpass.org
>
>
>      "GG" <anonymous@discussions.microsoft.com> wrote in message
>      news:FB5FA825-7B63-4B54-A681-15F2CD7648AF@microsoft.com...
>      > HI,
>      >> I am trying to run a job that contains one cmdexec step.  This
step
>      contains the following:
>      >> c:\file.bat
>      >> The bat calls the following:
>      > call file.vbs
>      >> This job fails.  I can run a simple ping command no problem but
the above
>      commands fail.
>      >> Any insight is appreciated.  I assume I must be calling something
>      incorrectly from a dts perspective but these commands all work from
the cmd
>      prompt.
>      >> Thanks in advance.
>
>
>

Relevant Pages

  • Re: Clustering with NAS
    ... Whilst I appreciate that clustering with NAS is ... >> Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: sql server mess? - please help
    ... >> Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.setup)
  • Re: Disabling DTS Bulk insert task
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Re: 812666 How to recover a failed full-text search resource on a clus
    ... Customer Service and Support (the new name for PSS - Product Support ... > Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: 3 Simple Security SQL Statements
    ... If you run the SELECT in a query window, it generates the list of commands ... There is procedure called sp_executesql that will take a string and execute ... Kalen Delaney, SQL Server MVP ... Builds a list of text commands. ...
    (microsoft.public.sqlserver.security)