diequintana (1/9/2013)
Thanks for your quick response.I’ll modify the sub plan A avoiding recovery model to be changed from full to simple. However I’ll leave that task in sub plan B because we had some space issues while performing test in the past.
Thanks for the recommended links I’ll consider include this rebuild index scripts instead of using the pre defined task.
Do you have any suggestion regarding email to operator’s issue? I was not able to find any log or error message indicating why the email had been not delivered.
Best regards. Thanks!
Remove the recovery model change from both A and B, unless you understand the effects that has on your recoveryabilty. If you have space issues while the plan runs, increase your transaction log backup schedule for the period the plan runs in.
Setting to SIMPLE breaks your log chain and will cause you problems if (touch wood this never happens) you need to restore your database.
Have you configured SQL Agent to use the alert system, and restarted the agent so the config gets picked up? If not when the job fails, the notifiy operator will not work.