How to automatically delete records in a table in sql server

gpmgpm

I have a problem now, because the records in the database are automatically collected by the system. There are too many records in the table, which seriously affects the efficiency of the database. Can there be a way in the sql server to automatically trigger it after a certain period of time. Delete the content in

michealhenry

Delete with assignment

wgfxman

Yes, build a job (JOB) and execute it regularly

菜鸟明星

job

seaeva

sp_add_job [@job_name =]'job_name'
[, [@enabled =] enabled]
[, [@description =]'description']
[, [@start_step_id =] step_id]
[, [@category_name =]'category']
[, [@category_id =] category_id]
[, [@owner_login_name =]'login']
[, [@notify_level_eventlog =] eventlog_level]
[, [@notify_level_email =] email_level]
[, [@notify_level_netsend =] netsend_level]
[, [@notify_level_page =] page_level]
[, [@notify_email_operator_name =]'email_name']
[, [@notify_netsend_operator_name =]'netsend_name']
[, [@notify_page_operator_name =]'page_name']
[, [@delete_level =] delete_level]
[, [@job_id =] job_id OUTPUT]

There is online help

gpmgpm

Thanks, huh