Hi Thomas,
I have some query to run CmdExec job.
I have a EXE file and I want to run it, I wrote the command as follows :
xp_cmdshell 'D:\Sites\Scheduler\bin\MailScheduler.exe', no_output
It runsucessfully, but the task is not done..... for which the MailScheduler.exe was.
Whenever I run wrote the command as
xp_cmdshell 'D:\Sites\Scheduler\bin\MailScheduler.exe'
It retuns 'NULL' value, but according to BOL it clearly shows only 1 or 0 are return.
Please advice.............
Regards,
R Mohanty
DBA
Netcradle
-----Original Message-----
From: Thomas Anthony
[mailto:mssqldba-ezmlmshield-x12548181.[Email address protected]
Sent: Saturday, August 28, 2004 1:30 PM
To: LazyDBA Discussion
Subject: RE: Permission to run CmdExec job steps
Ehhh, wrong. Only SA's can run extended stored procedures.
You have to configure a Windows Account to be used as the SQL Agent proxy account. Then, in the SQL Agent properties, there is check box that disallows anyone but the sysadmins from running command level jobs. If you disable this, you can add the account credentials for the account that will run user jobs when they are not sa's. This is bad practice.
In earlier versions, this was the CmdExec.
Have them set up there job then after inspections and testing, assign the sa as the owner of the job.
Sincerely,
Anthony Thomas, MCDBA, MCSA
-----Original Message-----
From: Uday Shivamurthy [mailto:mssqldba-ezmlmshield-x66856648.[Email address protected]
Sent: Thursday, August 26, 2004 6:55 PM
To: LazyDBA Discussion
Subject: FW: Permission to run CmdExec job steps
Hi Cesar,
You need to add this account as a "user" in the master db.
Then go the "stored procedures" in master db
Find "xp_cmdshell" and double click it
Click on "permissions"
Find your sql server login account and grant him/her "execute" permission
for this particular extended procedure.
Of-course you can do it all using t-sql, but, above method is easy for you.
Regards,
Uday
-----Original Message-----
From: cesaralt
[mailto:mssqldba-ezmlmshield-x89163693.[Email address protected]
Sent: Wednesday, 25 August 2004 9:32 AM
To: LazyDBA Discussion
Subject: Permission to run CmdExec job steps
Hi,
I am trying to run a scheduled DTS Package and I got the following message:
"Non-SysAdmins have been denied permission to run CmdExec job steps. The
step failed."
How Do I assign permissions to users to run DTS job
steps?
Thanks for any help.
Regards,
Cesar Altamirano
---------------------------------------------------------------
EC Red Internet [Email Address Removed] en www.ec-red.com
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
***********************************************************************
NOTICE: This electronic mail message and any attached files are
confidential. The information is exclusively for the use of the
individual or entity intended as the recipient. If you are not the
intended recipient, any use, copying, printing, reviewing, retention,
disclosure, distribution or forwarding of the message or any attached
file is not authorized and is strictly prohibited. If you have received
this electronic mail message in error, please advise the sender by reply
electronic mail immediately and permanently delete the original
transmission, any attachments and any copies of this message from your
computer system.
***********************************************************************
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
MS Sql Server LazyDBA home page