How to truncate table every month last day midnight 11:59pm

Posted by Satyadnet under Sql Server on 4/26/2009 | Views : 2414 | Status : [Member] | Replies : 1
Hi everybody,
Please let me know the answer.
Advance thanks..


Posted by: Vuyiswamb on: 4/27/2009 [Member] [MVP] [Administrator] NotApplicable

Good Morning Satyadnet

What you need an SSIS hosted in a Job. Create an SSIS Job and write your Sp that Trunace the Table and go to your SQl and create a Job that run Montly on the Last day and it will run it. here is the info about SSIS

And here is the Info on how to create a Job

Thank you for Posting at Dotnetfunda

Vuyiswa Maseko

Thank you for posting at Dotnetfunda

Satyadnet, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response