Database Engine Tuning Advisor (Apply Recommendations)
After a workload has been analyzed and recommendations have been presented, on the Actions menu, click Apply Recommendations to open the Apply Recommendations dialog box.
Options
Apply now
Generate a script for the recommendations, and runs the script to implement the recommendations.Schedule for later
Generate a script for the recommendations, and save the actions as a SQL Server Agent job.Date
Specify the date you want to run the SQL Server Agent job to apply the recommendations.Time
Specify the time you want to run the SQL Server Agent job to apply the recommendations.
See Also