Search code examples
sql-serversql-server-2008jobstimer-jobs

How to insert or delete query with jobs in SQL Server?


I want to insert or update or delete in database automatically after cross a time e.g 8 hours.

Is it with jobs in SQL Server?

Thanks.


Solution

  • You can create a SQL Server job with TSQL code in it and schedule this job as appropriate.