How execute exe file from sql agent or job?
43,174
Solution 1
Executable and batch files may be added to a job as step (MSDN Implement Jobs).
- Create a job
-
Add a new step
2.1 set "Operating system(CmdExec)" as type
2.2 set the executable path
Solution 2
If you must do it in JOB: xp_cmdshell xp_cmdshell execute as nonadmin!
DECLARE @command varchar(8000)
SET @command = 'C:\MyProgram'
EXEC master..xp_cmdshell @command
But you should shedule task in windows.
Author by
user1531248
Updated on July 09, 2022Comments
-
user1531248 almost 2 years
I don't want to hit the database frequently based on page request, so I planned to create a xml file using separate C# coding [exe file] & put in the common path to access from different page/project, which will do the hitting stuff's daily morning, so can you explain how do I execute exe file from sql job or agent by scheduled manner?
My scenario: database table will be updated only once, so I am going for a XML/txt file.
Thanks, S.Venkatesh
-
Kyle Johnson over 6 yearsTask Scheduler is better because it lets you run it under a specific domain account that may not be a user in SQL Server