Hi,
I was wondering if there is a way to customise e mail alerts that are sent
after a backup is taken of a database ?
I currently receive the following e mail alert format
JOB RUN: 'Northwind backup' was run on 14/01/2005 at 11:06:06
DURATION: 0 hours, 0 minutes, 0 seconds
STATUS: Succeeded
MESSAGES: The job succeeded. The Job was invoked by User
TESTSQLSERVER\Administrator. The last step to run was step 1 (Step 1).
I would prefer to have all this information condensed into a single line and
also condense the subject of the mail which is currently very long ,
" SQL Server Job System: 'Northwind backup' completed on \\TESTSQLSERVER"
to something that’s more meaningful at a glance.
Any help will be appreciated.
Disable the automatic notification and add your own notification steps to
the job.
You will probably need two steps
"report success" and "report failure"
Have each job step execute the "report failure" step if the specific step
fails.
Have the job execute the "report success" job step if there are not any
failures.
You will have to add the appropriate calls to exec master..xp_sendmail
within the "report success" or "report failure" job steps.
Keith
"Michael" <Michael@.discussions.microsoft.com> wrote in message
news:1A46B036-A6D5-4D0E-81A1-A7F887637A01@.microsoft.com...
> Hi,
> I was wondering if there is a way to customise e mail alerts that are sent
> after a backup is taken of a database ?
> I currently receive the following e mail alert format
> JOB RUN: 'Northwind backup' was run on 14/01/2005 at 11:06:06
> DURATION: 0 hours, 0 minutes, 0 seconds
> STATUS: Succeeded
> MESSAGES: The job succeeded. The Job was invoked by User
> TESTSQLSERVER\Administrator. The last step to run was step 1 (Step 1).
> I would prefer to have all this information condensed into a single line
and
> also condense the subject of the mail which is currently very long ,
> " SQL Server Job System: 'Northwind backup' completed on \\TESTSQLSERVER"
> to something that’s more meaningful at a glance.
> Any help will be appreciated.
>
|||Sorry to ask such an obvious question but where do I disable to automatic
notifications ?
"Keith Kratochvil" wrote:
> Disable the automatic notification and add your own notification steps to
> the job.
> You will probably need two steps
> "report success" and "report failure"
> Have each job step execute the "report failure" step if the specific step
> fails.
> Have the job execute the "report success" job step if there are not any
> failures.
> You will have to add the appropriate calls to exec master..xp_sendmail
> within the "report success" or "report failure" job steps.
> --
> Keith
>
> "Michael" <Michael@.discussions.microsoft.com> wrote in message
> news:1A46B036-A6D5-4D0E-81A1-A7F887637A01@.microsoft.com...
> and
>
|||Double-click on the job and look at the notification tab.
Keith
"Michael" <Michael@.discussions.microsoft.com> wrote in message
news:84954ADC-9016-4860-99E6-5F6DDD5550B9@.microsoft.com...[vbcol=seagreen]
> Sorry to ask such an obvious question but where do I disable to automatic
> notifications ?
> "Keith Kratochvil" wrote:
to[vbcol=seagreen]
step[vbcol=seagreen]
sent[vbcol=seagreen]
line[vbcol=seagreen]
\\TESTSQLSERVER"[vbcol=seagreen]
