How to manually create a Microsoft SQL Job to Age OWA data (4318774)

If your database is getting to large and you would like to get rid of some data but don't have sysadmin rights on the SQL Server to deploy the jobs through the MessageStats console you can give the Resolution to your Database Administrator.

1. Open SQL Management Studio
2. Expand Databases | MessageStats | Table and Right click on the dbo.T_OWA_Configuration table and select Open Table or Edit Top 200 Rows
3. Change the StatsRetentionDays to 365 and press enter. And close out the Tab
4. Expand SQL Server Agent and Right click on Jobs and Select New Job
5. In the General section For the Name: put QMSOWADataAge
6. For the Owner: make sure it is an account that is a sysadmin on the SQL server
7. In the General section for the Category: Select Database Maintenance
8. On the Steps Tab Select New
9. In the General section The Step name should be QMSOWADataAge_SQL_Step0
10. The Type should be Transact-SQL script (T-SQL)
11. The Database should be MessageStats
12. And in the Command section put EXEC PR_OWA_DataAging and Click OK
13. On the Schedules Tab please select New
14. For the Name Select QMS_SCHEDULE
15. For the Schedule Type Select Recurring and check the Enabled box.
16. For the Frequency we recommend setting this to run daily (Schedule at a time when the MessageStats Tasks are not running) And Click OK then OK again and the job has been created