![]() ![]() ![]() In case everything is as intended, press Finish to create the planĪfter pressing Finish, the plan will be created and we are going to be presented with an overview of completed tasks. In the Complete the Wizard page, we review the plan, if anything is not as intended, we can go back to change that. Since we have only one profile created, we choose that one for the reports. In the To: dropdown menu, we select which profile In the Select Report Options, we choose whether we would like to have a text file report of the maintenance plan actions written, as well as setting up the email notification for backup job we are creating. ![]() In Options tab you can configure other setting as per your requirements. In Destination Tab you can select path of your disk Select the maintenance task as Back Up Database (Full) and Click NextĬhoose the databases from the drop down menu you want to take the backup.Ĭhoose the backup destination such as Disk Tap or URL You can give any name to your plan such as backup plan etc. ![]() Expand the node for the server you are using, after that expand the Management folder, right click on Maintenance plans and select Maintenance Plan Wizard. After selecting that, press OK to update the already created job.Įmail notifications for Backup jobs using Maintenance Plansįirst open SSMS. Via email notification for backup job when the job is completed, successfully or not. When the job succeeds notifies the operator via email notification if the backup job has completed successfully, When the job fails notifies the operator via email notification for backup jobs if the job has failed and When the job completes notifies the operator Give any name to your Job, Go to Notification area and select your operator which we created earlier in Email section and select when the job complete option against it. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |