如何从sql代理或作业执行exe文件? [英] How execute exe file from sql agent or job?

问题描述

我不想根据页面请求频繁访问数据库，因此我计划使用单独的C#编码[exe文件]&放在从其他页面/项目进行访问的通用路径中，这将是每天早上工作的重点，所以您能解释一下如何按计划方式从sql作业或代理执行exe文件吗?

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?

我的情况:数据库表将仅更新一次，因此我要使用XML/txt文件.

My scenario: database table will be updated only once, so I am going for a XML/txt file.

谢谢，文卡特什(S.Venkatesh)

Thanks, S.Venkatesh

推荐答案

可执行文件和批处理文件可以作为步骤添加到作业中(

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

1. 创建工作

2. 添加新步骤

1. Create a job

2. Add a new step

2.1将操作系统(CmdExec)"设置为类型

2.1 set "Operating system(CmdExec)" as type

2.2设置可执行路径

2.2 set the executable path

这篇关于如何从sql代理或作业执行exe文件?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！