How execute exe file from sql agent or job?

Question

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

not sure i understand the question, but would love to see some answers! — Alex Gordon, Aug 01 '12 at 06:56
You should be using Task Scheduler in windows for starting your app. — linkerro, Aug 01 '12 at 07:00

Alberto De Caro · Answer 1 · 2022-09-30T07:18:46.333

31

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

edited Sep 30 '22 at 07:18

answered Aug 01 '12 at 07:55

Alberto De Caro

5,147
9
47
73

VoonArt · Answer 2 · 2012-08-01T11:19:55.627

7

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.

edited Aug 01 '12 at 11:19

answered Aug 01 '12 at 07:10

VoonArt

884
1
7
21

Task Scheduler is better because it lets you run it under a specific domain account that may not be a user in SQL Server – Kyle Johnson Jan 26 '18 at 20:26

How execute exe file from sql agent or job?

2 Answers2

Linked