sql server中如何一到时间就自动删除一个表中的纪录

gpmgpm

我现在遇到一个问题,因为数库中的纪录为系统自动采集,现在表格的纪录过多,严重影响了数据库的效率,请问在sql server中能不能有方法能隔一些时间自动触发,对表中的内容进行删除

michealhenry

用作业删除

wgfxman

对，建个作业(JOB)，定期执行

菜鸟明星

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 ]

联机帮助上有啊

gpmgpm

谢谢了,呵呵