1. Jobs : There is nothing new in the job so no explanation
2. Maintenance Plan
A Maintenance Plan can back up databases, delete old backup files from the operating system, maintain indexes, execute another job or shrink a DB
To access the Maintenance Plan Wizard, open Management Node in SSMS, right click Maintenance Plan, and choose Maintenance Plan Wizard
After that simply follow the steps and a corresponding job for the chosen task would be created
It is normally used in place of Jobs when one does not want to write TSQL code
DBA normally avoid maintenance plan due to their less flexibility, jobs are their favorite as in ING
Subscribe to:
Post Comments (Atom)
1 comment:
Hello. This post is likeable, and your blog is very interesting, congratulations :-). I will add in my blogroll =). If possible gives a last there on my blog, it is about the Placa de Vídeo, I hope you enjoy. The address is http://placa-de-video.blogspot.com. A hug.
Post a Comment