如何在Sql Server 2008 R2中安排作业 [英] How Do I Schedule A Job In Sql Server 2008 R2

问题描述

http://www.codeproject.com/Questions/748275/How-Do-I-Schedule-A-Job-In-Sql-Server-R

http：// www。 codeproject.com/Questions/748018/How-Do-I-Schedule-A-Job-In-Sql-Server-R



这是我以前的问题。来自解决方案我已经清楚地知道我无法在我的权限有限的服务器中设置工作。



现在我想知道有没有其他程序

我的意思是我想在服务器的时间基础上执行一些存储过程或sql查询。像一些查询或存储过程将在10分钟后在服务器中自动执行并产生一些结果给客户端

i我正在使用vs10（vb.net）和sql server 2008

http://www.codeproject.com/Questions/748275/How-Do-I-Schedule-A-Job-In-Sql-Server-R
http://www.codeproject.com/Questions/748018/How-Do-I-Schedule-A-Job-In-Sql-Server-R

this was my previous questions.from the solutions i have clearly understand that i can not set a job in server where my permissions are limited.

now i want to know that is there any other procedure
I mean i want to execute some store procedure or sql query in the server time to time basis.Like some query or store procedure will execute automatically in the server after 10 mins and produce some result to the client
i am using vs10 (vb.net) and sql server 2008

推荐答案

如果您对服务器没有权限那么你唯一的事情就是可以做的是在你的应用程序中安排一个计时器（这意味着你的应用程序必须一直运行）。



http://www.dotnetperls.com/timer-vbnet [ ^ ]

If you don't have permissions on your server then the only thing you can do is schedule a timer in your application (this means your app must be running all the time).

http://www.dotnetperls.com/timer-vbnet[^]

除 Mehdi Gholam的 [ ^ ]解决方案，一些替代品是



Windows任务计划程序 [ ^ ]

Quartz调度程序 [ ^ ]

In Addition to Mehdi Gholam's[^] Solution , some alternatives are

windows task scheduler[^]
Quartz scheduler[^]

这篇关于如何在Sql Server 2008 R2中安排作业的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！