Re: Job owned by a non-sysadmin fails to run

Looks like I have a problem with CmdExec jobs in general.

I changed the step command to "dir c:\temp" and it ran fine when owned by an
admin but failed when owned by a user. In case of being owned by a user even
the output file was not created. The folder c:\temp has "full control"
permission granted to everyone.

"Dan Guzman" <guzmanda@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:42FF0C9C-4AFC-42AF-9464-0931A1DDE13B@xxxxxxxxxxxxxxxx
I'm starting to run out of ideas. Do you have any CmdExec job steps that
successfully run as non-sysadmin users or is it just dmlrun.exe that has
the problem?

--
Hope this helps.

Dan Guzman
SQL Server MVP


.

Relevant Pages

  • Re: BCP command where the arguments have a special char
    ... >>> Try queryout like the example below. ... >> Dan Guzman ... >> SQL Server MVP ... the command gives a syntax error. ...
    (microsoft.public.sqlserver.programming)
  • Re: Save as in SQL Server(Backup - Restore)
    ... "Dan Guzman" wrote in message ... > SQL Server MVP ... I take it you already know about the RESTORE command ... >>> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: VBscript Timed out
    ... Do you know how to return the Connection Timeout value ... > property of the ADO Command object. ... > Dan Guzman ... > SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Restore Database
    ... we tend to ask for exact output and the command ... >>Tibor Karaszi, SQL Server MVP ... >>>>specified in the RESTORE command. ...
    (microsoft.public.sqlserver.server)
  • Re: Job owned by a non-sysadmin fails to run
    ... redirecting stdout/stderr to a file using on the command line: ... execution contexts. ... SQL Server MVP ... Mapped drives are not accessed. ...
    (microsoft.public.sqlserver.security)