CODEWITHSUNDEEP
c#sqlsql-agent-job
user1531248
user1531248

Reputation: 531

How execute exe file from sql agent or job?

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

Upvotes: 18

Views: 52380

Answers (2)

Alberto De Caro
Alberto De Caro

Reputation: 5213

Executable and batch files may be added to a job as step (MSDN Implement Jobs).

  1. Create a job
  2. Add a new step

2.1 set "Operating system(CmdExec)" as type

2.2 set the executable path

enter image description here

Upvotes: 32

VoonArt
VoonArt

Reputation: 904

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.

Upvotes: 7

Related Questions