How to setup SQL Server to delete/reset table every Monday morning

• nilknarf1972

  SSC Enthusiast

  Points: 114

  More actions

  February 17, 2020 at 4:48 pm

  #3726508

  I would like to try and reset/delete incidents from a table every Monday morning

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  February 17, 2020 at 5:13 pm

  #3726523

  Not exactly what you mean by reset/delete,  reset can have a different meaning than delete.  If you are talking about deleting all the data from the table once a week on a Monday, setup a SQL Agent job that runs in the appropriate database at the appropriate time and runs the following SQL statement:  TRUNCATE TABLE dbo.yourincidentstablenamehere;

   

  • This reply was modified 5 years, 3 months ago by Lynn Pettis.

• nadineriley

  Grasshopper

  Points: 11

  More actions

  March 5, 2020 at 2:00 am

  #3731237

  Lynn Pettis wrote:

  Not exactly what you mean by reset/delete,  reset can have a different meaning than delete.  If you are talking about deleting all the data from the table once a week on a Monday, setup a SQL Agent job that runs in the appropriate database at the appropriate time and runs the following SQL statement:  TRUNCATE TABLE dbo.yourincidentstablenamehere; google street view

  Oh that was it, great thank you so much!

  • This reply was modified 5 years ago by nadineriley.