March 28, 2012 at 9:42 am
Need to know how to Create a job to run a .exe program without using cmdexec in the job setup?
March 28, 2012 at 10:00 am
I did not say it before but this is in Sql server.
March 28, 2012 at 10:01 am
Need to know how to Create a job in SQL Server to run a .exe program without using cmdexec in the job setup?
March 28, 2012 at 10:05 am
Powershell?
March 28, 2012 at 10:08 am
Would you by chance have a script for powershell?
March 28, 2012 at 10:13 am
If you are creating a job to run an exe file, why wouldn't you use the cmdexec environment for the jobstep?
March 28, 2012 at 10:13 am
Could you use xp_cmdshell?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 28, 2012 at 10:18 am
Because I was told you will have to give too much security access on sql server agent.
March 28, 2012 at 10:24 am
Have you thought about running the exe using the windows OS job scheduler?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 28, 2012 at 10:28 am
veronica.smiley01 (3/28/2012)
Because I was told you will have to give too much security access on sql server agent.
Not sure I buy this argument. I have setup jobs that use cmdexec and have had no issues with it.
March 28, 2012 at 11:22 am
Do you have any good powershell scripts that would exec a program in Sql Server?
March 28, 2012 at 11:37 am
Do you have any good powershell scripts that would exec a program in Sql Server?
March 28, 2012 at 11:39 am
I don't know powershell and do not know how to write the script that would run an exe program in job setup.
March 28, 2012 at 12:11 pm
Barking up the wrong tree with me. I haven't learned PowerShell yet.
March 28, 2012 at 12:36 pm
Thanks for you help.
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply