Which system stored procedure should the job execute?
You are the SQL administrator for your company. Two SQL Server 2008 computers, named SQL1 and SQL2 ,have been deployed.
Several reports run on a daily basis and are e-mailed to the appropriate personnel using Database Mail. The msdb database is growing much larger than expected, and you discover that this is due to the volume of e-mailmessages generated by Database Mail. You need to delete all e-mail messages that are more than 30 days oldfrom the msdb database.
You decide to create a job that will automatically run once each week. Which system stored procedure should the job execute?