How to sechudle job move the active data from one table to another database table in sql

Question

How to schedule a job move the active data from one table to another database table in sql.

Answer 1

Hello

There are multiple options.. The one I suggest is to create a script (or stored procedure) to DELETE from the source table using OUTPUT clause so you will be sending the deleted rows to another table which will be defined by you. Use that script on a SQL Agent Job and schedule it to be executed at the time you need

here is the explanation and some examples of OUTPUT clause (Transact-SQL)

hope it helps

Regards

Javier

Answer 2

Hi @NAVINN T

How to schedule a job move the active data from one table to another database table in sql.

Regarding Schedule a Job, please refer to this tech doc: Schedule a Job.

Regarding move the active data from one table to another database table, you could use SELECT INTO Query. Also, you could use SQL Server Export/Import wizard or use Generate Scripts.

Please refer to this article for more details: How to copy tables from one database to another in SQL Server.

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.