sql-server sql-server-2008 jobs timer-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.

Using Dapper one-to-many (spliton) with generics
How to join two SELECT queries
Join two SELECT queries having same column names but different row values in both tables
How can you represent inheritance in a database?
String_agg for SQL Server before 2017
How can I remove accents on a string?
SQL - order by list order
Convert varchar list to int in Sql Server
"č" converted to "c" when querying through SQL Server 2008
SQL Server 2016, Invalid object name 'STRING_SPLIT'
SQL: Data Transpose
How do I create a unique key that is case sensitive?
ODBC Data Sources; can't add MySQL Driver
SQL Server - how to query JSON string which has numeric value as keys
BizTalk 2020 WCF-Sql Polling Receive Location no Response
Pyodbc: Login Timeout Error
Unable to upload rdl SSRS 2016
Database's backup location that created by Azure Data Studio on Mac M1
Entity Framework: The instance of entity type '<T>' cannot be tracked because another instance with the key value '{Id: x}' is already being tracked
Check if a connection is in a transaction
Can I have multiple rows of tabs in SQL Server Management Studio
SQL Server: Make all UPPER case to Proper Case/Title Case
How to disable transactions for individual migrations in Flyway on SQL Server
Natural (human alpha-numeric) sort in Microsoft SQL 2005
SQL how to do a LIKE search on each value of a declared variable
Roll Up with column changes
How to open a huge .sql file
ExecuteReader TimeOut solved by changing the name of the stored procedure
How do I get list of all tables in a database using TSQL?
SQL Database in restoring mode