sql作业，每隔一定时间运行并执行控制台应用程序 [英] sql job to run every certain time and execute a console application

问题描述

我试图编写一个每10分钟运行一次的SQL作业，并执行我用C#编写的控制台应用程序.

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.

推荐答案

您想要的是一个带有CmdExec步骤(可以执行Windows命令行)的SQL Server代理作业.此处说明: http://msdn.microsoft.com/zh-cn/library/ms190264.aspx

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

如果需要考虑安全性，则可以通过使用SQL Agent代理定义来确保安全性.此处说明: http://msdn.microsoft.com/en-us/library/ms189064(SQL.105).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

这篇关于sql作业，每隔一定时间运行并执行控制台应用程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！