How execute exe file from sql agent or job?

c# sql sql-agent-job
user1531248 picture user1531248 · Aug 1, 2012 · Viewed 40.6k times · Source

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

Answer

Alberto De Caro picture Alberto De Caro · Aug 1, 2012

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

Related questions

What is the syntax for an inner join in LINQ to SQL?

I'm writing a LINQ to SQL statement, and I'm after the standard syntax for a normal inner join with an ON clause in C#. How do you represent the following in LINQ to SQL: select DealerContact.* from Dealer inner join …

Read More
Fastest Way of Inserting in Entity Framework

I'm looking for the fastest way of inserting into Entity Framework. I'm asking this because of the scenario where you have an active TransactionScope and the insertion is huge (4000+). It can potentially last more than 10 minutes (default timeout of transactions), …

Read More
Read SQL Table into C# DataTable

I've read a lot of posts about inserting a DataTable into a SQL table, but is there an easy way to pull a SQL table into a .NET DataTable?

Read More