在特殊时间做一些任务 [英] Doing Some tasks at special times

问题描述

嗨每一个



考虑到有一些桌子。



我想做一些每小时都有特殊任务。

我的意思是更新或删除等任务。

我是否必须使用DATEDIFF功能？



任何帮助将不胜感激



tnx all

解决方案

嗯，你可以利用SQL Server作业。安排它使它每小时运行。请参阅下面的链接。



创建SQL Server代理作业 [ ^ ]



安排工作 [ ^ ]



创建工作 [ ^ ]



如何创建sql server 2005中的一项工作 [ ^ ]



SQL Server 2008创建和安排工作 [ ^ ]



如何在SQL Server 2005中安排和运行SSIS包（DTS）作业 [ ^ ]



SQL Server代理的调度程序GUI [ ^ ]



问候......：笑：

拜托请参阅下面的链接。



http://stackoverflow.com/questions/2348863/how-to-run-a-stored-procedure-in-sql-server-every-hour



http://stackoverflow.com/questions/16187222/execute-the-script-itself-in-every-5-min-by-getting-the-system-time

Hi every one

Consider that there are some tables.

I want to do some special tasks every hour.
I mean tasks like update or delete.
Do I have to use DATEDIFF function?

any help would be appreciated

tnx all

解决方案

Well,you can make use of SQL Server Jobs. Schedule it such that it runs every hour.Refer to below links.

Creating SQL Server Agent Jobs[^]

Schedule a Job[^]

Create a Job[^]

How to create a job in sql server 2005[^]

SQL Server 2008 -Create and Schedule Job[^]

How to Schedule and Run a SSIS package ( DTS ) Job in SQL Server 2005[^]

A scheduler GUI for SQL Server Agent[^]

Regards.. :laugh:

Hi, please see the links below.

http://stackoverflow.com/questions/2348863/how-to-run-a-stored-procedure-in-sql-server-every-hour

http://stackoverflow.com/questions/16187222/execute-the-script-itself-in-every-5-min-by-getting-the-system-time

这篇关于在特殊时间做一些任务的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！