创建定时事件的帮助不大 [英] Little help with creating a timed event

问题描述

这就是我想发生的事情

Here is what I would like to happen

CREATE TRIGGER EmployeeClockin ON Timeclock

FOR Insert

AS

Catch inserted time and have a timer running against it.

If timer >6 hours 

Send email

我已经准备好了大部分代码，只是不知道我想在SQL中实现什么功能.

我收到了工作的电子邮件，等等，我只需要一些可以在经过一定时间后触发的电子邮件.

我通常使用VB编写代码，而在涉及SQL时，我还是有点绿色，因此任何帮助都很好:)

I have most of the code I need all ready written, I just have no idea if what I want to happen is possible in SQL.

I got the email to work, etc, I just need something that will fire this off after a certain amount of time has passed.

I usually write in VB and im still a little green when it comes to SQL so any help would be great :)

推荐答案

据我所知像您尝试的那样以编程方式使用SQL Server做到这一点的方法.它仅允许通过 SQL Server代理作业 [

To the best of my knowledge there is no way to do this with SQL server in a programmatic fashion like you are trying to do. It only allows scheduled running of jobs by means of SQL Server Agent jobs[^].

这篇关于创建定时事件的帮助不大的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！