一定时间后如何执行sql查询

问题描述

大家好

我正在做一个应用程序，大约30分钟后，我必须从数据库中删除一个perticuler用户数据.
谁能告诉我该怎么做..

Hi all

i am doing one application where after 30 min(approx.) i have to delete a perticuler users data from the DB.
can any one tell me how to do that..

推荐答案

MsSQL -> ObjExplorer -> SqlServerAgent ->New (if not accessible then start sql agent service)-> Job ->

in this new window,
general tab -> Name=test
               Desc=trial...
               check 'Enable' option
Steps tab -> New -> StepName=one      type=trans-SqlScr(TSQL)
                    Database=Your_DB
                    cmd= Copy paste all your delete queries here.

                    Advance tab -> On success action=Quit the job

Schedule tab -> New -> Name=From Morning daily
                       Schedule type= Reccuring
                       check 'Enable' option
                       Daily Frequency => check 'Occure once' at = 10 AM
                                          check 'No End date'
OK

有关更多详细信息，请参见链接

for more details refer link

http://www.codeproject.com/Answers/436811/With-out-vs-2010-front-end-i-want-to-delete-multip#answer2

祝您编码愉快！
:)

Happy Coding!
:)

这篇关于一定时间后如何执行sql查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！