sqlserver中的JOB SCHEDULER示例 [英] Sample for JOB SCHEDULER in sqlserver
本文介绍了sqlserver中的JOB SCHEDULER示例的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
嗨亲爱的朋友；
当某些数据在24小时后未更新时，我想从表中自动删除数据
如果您有一些样品请发送给我或帮助我
Tanks
hi dear friends;
I want to automatic delete data from table when some of data not updated after 24 hours
If you have some sample pleas send for me or help me
Tanks
推荐答案
为什么一遍又一遍地问同样的问题?
人们已经回答了您以前的帖子
SqlServer中的作业调度程序 [ SqlServer中的作业计划程序 [
Why are you asking the same question over and over?
People have already answered your previous posts
Job scheduler in SqlServer[^]
Job scheduler in SqlServer[^]
要添加到上一个答案，如果问题是您拥有没有Sql Agent的SQL Server Express Edition，则不能使用本机调度程序.
如果是这样，请查看此文章: SQL代理:作业调度程序框架 [ ^ ]
To add to the previous answer, if the problem is that you have SQL Server Express Edition which doesn''t have an Sql Agent, you cannot use the native scheduler.
If that''s the case, have a look at this article: SQL Agent: A Job Scheduler Framework[^]
这篇关于sqlserver中的JOB SCHEDULER示例的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
