Backup and notify operator

We are using SQL Server 2005.
We do transaction backup every 15 minutes and we notify the operator by
email every time after the backup. So, there is a lot of emails the whole
day.
I am wondering if there is a way to only notify the operator only when there
is a problem with the backup.
Thank you.On Job Pproperties, Notifications, E-mail there are three choices. Perhaps
you are using 'When the job completes'. Select 'When the job fails' instead.
Hope this helps,
Ben Nevarez
"fniles" wrote:
> We are using SQL Server 2005.
> We do transaction backup every 15 minutes and we notify the operator by
> email every time after the backup. So, there is a lot of emails the whole
> day.
> I am wondering if there is a way to only notify the operator only when there
> is a problem with the backup.
> Thank you.
>
>|||Thank you.
When I right click - Edit on the Notify Operator Task, I only see "operators
to notify" and "notification message to send:"
I do not see the 3 choices. Is this because I am using SQL Server 2005
Developer version ?
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:C8F93DF7-A7AD-422E-8C02-3A818F0270D9@.microsoft.com...
> On Job Pproperties, Notifications, E-mail there are three choices. Perhaps
> you are using 'When the job completes'. Select 'When the job fails'
> instead.
> Hope this helps,
> Ben Nevarez
>
>
> "fniles" wrote:
>> We are using SQL Server 2005.
>> We do transaction backup every 15 minutes and we notify the operator by
>> email every time after the backup. So, there is a lot of emails the whole
>> day.
>> I am wondering if there is a way to only notify the operator only when
>> there
>> is a problem with the backup.
>> Thank you.
>>|||Developer Edition is fine. Go to Jobs, double-click your job, Notifications,
E-mail must be checked, on the right there is a list. Select the list.
Perhaps you are using 'When the job completes'. Select 'When the job fails'
instead.
Hope this helps,
Ben Nevarez
"fniles" wrote:
> Thank you.
> When I right click - Edit on the Notify Operator Task, I only see "operators
> to notify" and "notification message to send:"
> I do not see the 3 choices. Is this because I am using SQL Server 2005
> Developer version ?
> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
> news:C8F93DF7-A7AD-422E-8C02-3A818F0270D9@.microsoft.com...
> >
> > On Job Pproperties, Notifications, E-mail there are three choices. Perhaps
> > you are using 'When the job completes'. Select 'When the job fails'
> > instead.
> >
> > Hope this helps,
> >
> > Ben Nevarez
> >
> >
> >
> >
> > "fniles" wrote:
> >
> >> We are using SQL Server 2005.
> >> We do transaction backup every 15 minutes and we notify the operator by
> >> email every time after the backup. So, there is a lot of emails the whole
> >> day.
> >> I am wondering if there is a way to only notify the operator only when
> >> there
> >> is a problem with the backup.
> >> Thank you.
> >>
> >>
> >>
>
>|||It looks like you were referring to SQL 2000. I do see what you are
referring to in SQL 2000. I am using SQL 2005. I do not see "Jobs" in SQL
2005.
Do you know how I can do this in SQL 2005 ?
Thank you.
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:BC2F9E23-D44D-40C3-BB49-55910DA35015@.microsoft.com...
> Developer Edition is fine. Go to Jobs, double-click your job,
> Notifications,
> E-mail must be checked, on the right there is a list. Select the list.
> Perhaps you are using 'When the job completes'. Select 'When the job
> fails'
> instead.
> Hope this helps,
> Ben Nevarez
>
>
> "fniles" wrote:
>> Thank you.
>> When I right click - Edit on the Notify Operator Task, I only see
>> "operators
>> to notify" and "notification message to send:"
>> I do not see the 3 choices. Is this because I am using SQL Server 2005
>> Developer version ?
>> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
>> news:C8F93DF7-A7AD-422E-8C02-3A818F0270D9@.microsoft.com...
>> >
>> > On Job Pproperties, Notifications, E-mail there are three choices.
>> > Perhaps
>> > you are using 'When the job completes'. Select 'When the job fails'
>> > instead.
>> >
>> > Hope this helps,
>> >
>> > Ben Nevarez
>> >
>> >
>> >
>> >
>> > "fniles" wrote:
>> >
>> >> We are using SQL Server 2005.
>> >> We do transaction backup every 15 minutes and we notify the operator
>> >> by
>> >> email every time after the backup. So, there is a lot of emails the
>> >> whole
>> >> day.
>> >> I am wondering if there is a way to only notify the operator only when
>> >> there
>> >> is a problem with the backup.
>> >> Thank you.
>> >>
>> >>
>> >>
>>|||If I am understanding correctly what you have done, you have created a
maintenance plan in SQL 2005. In that maintenance plan (actually that
sub-plan), you have two tasks. The backup task and a notify operator
task, connected by a precedence constraint (green line with an arrow
pointing to the notify operator task).
If so, just right click on the precedence constraint and change it from
success to failure. Then, the notify operator task will only run when
the preceding task fails.
HTH,
Jeff
fniles wrote:
> It looks like you were referring to SQL 2000. I do see what you are
> referring to in SQL 2000. I am using SQL 2005. I do not see "Jobs" in SQL
> 2005.
> Do you know how I can do this in SQL 2005 ?
> Thank you.
> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
> news:BC2F9E23-D44D-40C3-BB49-55910DA35015@.microsoft.com...
>> Developer Edition is fine. Go to Jobs, double-click your job,
>> Notifications,
>> E-mail must be checked, on the right there is a list. Select the list.
>> Perhaps you are using 'When the job completes'. Select 'When the job
>> fails'
>> instead.
>> Hope this helps,
>> Ben Nevarez
>>
>>
>> "fniles" wrote:
>>
>> Thank you.
>> When I right click - Edit on the Notify Operator Task, I only see
>> "operators
>> to notify" and "notification message to send:"
>> I do not see the 3 choices. Is this because I am using SQL Server 2005
>> Developer version ?
>> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
>> news:C8F93DF7-A7AD-422E-8C02-3A818F0270D9@.microsoft.com...
>> On Job Pproperties, Notifications, E-mail there are three choices.
>> Perhaps
>> you are using 'When the job completes'. Select 'When the job fails'
>> instead.
>> Hope this helps,
>> Ben Nevarez
>>
>>
>> "fniles" wrote:
>>
>> We are using SQL Server 2005.
>> We do transaction backup every 15 minutes and we notify the operator
>> by
>> email every time after the backup. So, there is a lot of emails the
>> whole
>> day.
>> I am wondering if there is a way to only notify the operator only when
>> there
>> is a problem with the backup.
>> Thank you.
>>
>>
>>
>
>|||Thank you.
If I change it to failure, if the process only fail partially, will it
report it to the operator ?
"Jeffrey Williams" <jeff.williams3188@.verizon.net> wrote in message
news:e7uo%23IXVIHA.2368@.TK2MSFTNGP05.phx.gbl...
> If I am understanding correctly what you have done, you have created a
> maintenance plan in SQL 2005. In that maintenance plan (actually that
> sub-plan), you have two tasks. The backup task and a notify operator
> task, connected by a precedence constraint (green line with an arrow
> pointing to the notify operator task).
> If so, just right click on the precedence constraint and change it from
> success to failure. Then, the notify operator task will only run when the
> preceding task fails.
> HTH,
> Jeff
> fniles wrote:
>> It looks like you were referring to SQL 2000. I do see what you are
>> referring to in SQL 2000. I am using SQL 2005. I do not see "Jobs" in SQL
>> 2005.
>> Do you know how I can do this in SQL 2005 ?
>> Thank you.
>> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
>> news:BC2F9E23-D44D-40C3-BB49-55910DA35015@.microsoft.com...
>> Developer Edition is fine. Go to Jobs, double-click your job,
>> Notifications,
>> E-mail must be checked, on the right there is a list. Select the list.
>> Perhaps you are using 'When the job completes'. Select 'When the job
>> fails'
>> instead.
>> Hope this helps,
>> Ben Nevarez
>>
>>
>> "fniles" wrote:
>>
>> Thank you.
>> When I right click - Edit on the Notify Operator Task, I only see
>> "operators
>> to notify" and "notification message to send:"
>> I do not see the 3 choices. Is this because I am using SQL Server 2005
>> Developer version ?
>> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
>> news:C8F93DF7-A7AD-422E-8C02-3A818F0270D9@.microsoft.com...
>> On Job Pproperties, Notifications, E-mail there are three choices.
>> Perhaps
>> you are using 'When the job completes'. Select 'When the job fails'
>> instead.
>> Hope this helps,
>> Ben Nevarez
>>
>>
>> "fniles" wrote:
>>
>> We are using SQL Server 2005.
>> We do transaction backup every 15 minutes and we notify the operator
>> by
>> email every time after the backup. So, there is a lot of emails the
>> whole
>> day.
>> I am wondering if there is a way to only notify the operator only
>> when
>> there
>> is a problem with the backup.
>> Thank you.
>>
>>
>>
>>|||What do you mean by fail partially? Either the task completes
successfully, or the task fails - there is no partial failure.
But, if you have multiple tasks in the sub-plan and a single notify
operator task - with all tasks connected to the notify operator task on
failure the notify operator task will only fire if all tasks fail. To
get the notify operator task to fire if any one task fails you need to
right-click on one of the failure (red arrow) constraints and change
from AND to OR condition.
Or, you can add a separate notify operator task for each individual task
in the sub-plan. For example, you would have a Check Database Integrity
Task, Rebuild Index Task, Update Statistics, Backup Task and Cleanup
Task (connected in order on success) with a notify operator task
connected to the Database Integrity Task, a separate notify operator
task connected to the Rebuild Index Task, etc...
fniles wrote:
> Thank you.
> If I change it to failure, if the process only fail partially, will it
> report it to the operator ?
> "Jeffrey Williams" <jeff.williams3188@.verizon.net> wrote in message
> news:e7uo%23IXVIHA.2368@.TK2MSFTNGP05.phx.gbl...
>> If I am understanding correctly what you have done, you have created a
>> maintenance plan in SQL 2005. In that maintenance plan (actually that
>> sub-plan), you have two tasks. The backup task and a notify operator
>> task, connected by a precedence constraint (green line with an arrow
>> pointing to the notify operator task).
>> If so, just right click on the precedence constraint and change it from
>> success to failure. Then, the notify operator task will only run when the
>> preceding task fails.
>> HTH,
>> Jeff
>> fniles wrote:
>> It looks like you were referring to SQL 2000. I do see what you are
>> referring to in SQL 2000. I am using SQL 2005. I do not see "Jobs" in SQL
>> 2005.
>> Do you know how I can do this in SQL 2005 ?
>> Thank you.
>> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
>> news:BC2F9E23-D44D-40C3-BB49-55910DA35015@.microsoft.com...
>>
>> Developer Edition is fine. Go to Jobs, double-click your job,
>> Notifications,
>> E-mail must be checked, on the right there is a list. Select the list.
>> Perhaps you are using 'When the job completes'. Select 'When the job
>> fails'
>> instead.
>> Hope this helps,
>> Ben Nevarez
>>
>>
>> "fniles" wrote:
>>
>> Thank you.
>> When I right click - Edit on the Notify Operator Task, I only see
>> "operators
>> to notify" and "notification message to send:"
>> I do not see the 3 choices. Is this because I am using SQL Server 2005
>> Developer version ?
>> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
>> news:C8F93DF7-A7AD-422E-8C02-3A818F0270D9@.microsoft.com...
>>
>> On Job Pproperties, Notifications, E-mail there are three choices.
>> Perhaps
>> you are using 'When the job completes'. Select 'When the job fails'
>> instead.
>> Hope this helps,
>> Ben Nevarez
>>
>>
>> "fniles" wrote:
>>
>>> We are using SQL Server 2005.
>>> We do transaction backup every 15 minutes and we notify the operator
>>> by
>>> email every time after the backup. So, there is a lot of emails the
>>> whole
>>> day.
>>> I am wondering if there is a way to only notify the operator only
>>> when
>>> there
>>> is a problem with the backup.
>>> Thank you.
>>>
>>>
>>>
>>>
>>>
>>
>
>