Update table on every 24 hours using SQL Server Job Scheduler

Question

HelloHow i can update the table status after 24 hours of entry into table automaticallythrough sql server 2008The table should be automatically update or even

Mudassar · Accepted Answer

You can create a SQL JobAutomated Email Notifications using SQL Server Job Schedular Or use a Windows ServiceCreate Windows Service in Visual Studio 2013 2015 and 2017 using C and VBNet

kalpesh · Answer

Article Links which already shared in reply httpwwwaspforumsnetThreads171151Howtoupdatetableafter24housReplies1Replies for Automated Email Notification Please refer that You just need to create the New Job as per step explained in the article link As per your requirement you just need to make change in Job from SqlCommand type to Sets its Schedule TimeIf you need to check the Status column whose value is reserve from the table which you want to delete if it not confirm after passing 24 hour then you need to check datedifrrence of DateTime column by using DateDiff function of sql also need to check the status is Reserve if its reserve and time passed as more than equal to 24 hour then you can delete itBelow is sample SqlCommandQuery to check the datediffrence more than equal to 24 hr also check status column whose values is ReserveDELETE FROM TableName WHERE DATEDIFFHHYourCompareDateColumnNameGETDATE gt 24AND UPPERStatusColumnName  39RESERVE39Just

Update table on every 24 hours using SQL Server Job Scheduler

Company

Explore

Follow us

Contact Us