Scripts need for purging the auditing data
Posted on 2011-09-14
Can any one Please tell me how to write a script for purging the audit data from tables .
I am using the windows, i want to shedule the job using SHEDULED TASKS
I need to 2 scripts
1st is for purging the auditing data from source table ( database1) to Stage table (database 2) .
I want to keep the data in stage table for 3 months.
2nd is purging the auditing data from Stage table(database 2) to Final table(database 2)
I want to keep the data in final table for 1 year.