2

I am trying to write a SQL job to run every 10 minutes and to execute a console application that I wrote in C#.

It would be really helpful if someone could help.

Lee Taylor
  • 7,761
  • 16
  • 33
  • 49
ainFowara
  • 109
  • 2
  • 3
  • 6
  • Why not use a Windows Scheduled Task instead? – Bobson Jan 10 '13 at 20:22
  • Yeah.. Why not a Scheduled task? A scheduled task lets you schedule running and exe periodically – Dhawalk Jan 10 '13 at 20:23
  • Please provide the brand, version and edition of SQL that you are trying to use. – RBarryYoung Jan 10 '13 at 20:25
  • am not using windows scheduled task cause its something related to falling of the server that my console application is on. thanks for the suggestion, I was thinking about, but its not good for my case. – ainFowara Jan 10 '13 at 20:28
  • It would be really helpful if you detailed what you have tried to do and what problem you actually have. It is not clear from your post what your problem is since you did not ask a question. – PhoenixReborn Jan 10 '13 at 20:32

1 Answers1

3

What you want is a SQL Server Agent Job, with a CmdExec step (which can execute a windows command line). This is explained here: http://msdn.microsoft.com/en-us/library/ms190264.aspx

If security is a concern, it can be secured through the use of a SQL Agent Proxy definition. This is explained here: http://msdn.microsoft.com/en-us/library/ms189064(SQL.105).aspx

RBarryYoung
  • 55,398
  • 14
  • 96
  • 137