mostafa hadian
Reputation: 3
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.
Upvotes: -2
Views: 161
Answers (1)
Laeeq
Reputation: 66
You can create a SQL Server job with TSQL code in it and schedule this job as appropriate.
Upvotes: 0
Related Questions
- How to concatenate text from multiple rows into a single text string in SQL Server
- How to return only the Date from a SQL Server DateTime datatype
- How to add a column with a default value to an existing table in SQL Server?
- What is the best way to auto-generate INSERT statements for a SQL Server table?
- Reset identity seed after deleting records in SQL Server
- How do I UPDATE from a SELECT in SQL Server?
- How to check if a column exists in a SQL Server table
- SQL update query using joins
- How can I do an UPDATE statement with JOIN in SQL Server?
- How can I delete using INNER JOIN with SQL Server?