Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kvt.aravind
Starting Member
24 Posts |
 Posted - 2010-09-07 : 01:32:06
|
| Kindly help am new to sql server..I have to create to a stored procedure that deletes records which are older than 90 days in production db and keeps that deleted records in archive db... this stored procedure has to be executed daily automatically after working hours and a mail has to be sent to concerned persons once it is executed daily with the records that are deleted....Kindly help ...give your ideasAravind.T |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2010-09-07 : 01:34:17
|
| Read about sql jobs and Sql mailSenthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
 |
|
|
|
|
|
stored procedure to execute automatically daily