How to schedule a stored procedure in SQL Server

Question

I have a stored procedure, and I want to delete rows daily for more than 30 days.

Which means, everyday a bit of data is saved (new record) in database, and the first day data will be deleted after 30 days.

Again in everyday.

DELETE ????
FROM Table1
WHERE  ????

And Table1 :

ID         INT
Name1      TinyInt
Name2      TinyInt
Name3      TinyInt
DateT      DateTime

The question is duplicate, see https://stackoverflow.com/questions/5471080/how-to-schedule-a-job-for-sql-query-to-run-daily — M. Rezaeyan, Jul 23 '17 at 12:11
Possible duplicate of [how to schedule a job for sql query to run daily?](https://stackoverflow.com/questions/5471080/how-to-schedule-a-job-for-sql-query-to-run-daily) — Evaldas Buinauskas, Jul 23 '17 at 12:14
this is my question : " the first day data will be deleted after 30 days." And that not my answer . Please Read first and then answer(negative). — Safa, Jul 24 '17 at 03:30

score 0 · Accepted Answer · answered Jul 24 '17 at 06:45

0

Found it.

In SQL Server Agent,

DELETE FROM table1
      WHERE DateT > dateadd(day, -30, getdate()) and DateT < dateadd(day, -29, getdate())

answered Jul 24 '17 at 06:45

Safa

Just be careful about the time component here. What datatype is DateT? Does it have a time component? – Nick.Mc Jul 24 '17 at 06:49
@Nick.McDermaid Type is 'DateTime'. – Safa Jul 24 '17 at 07:12

1 Answers1