|
Customizing Agent Mail Backup Content
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 thatb s more meaningful at a glance.
Any help will be appreciated.
Fri, 14 Jan 2005 05:21:03 -0800
"=?Utf-8?B?TWljaGFlbA==?="
|
Re: Customizing Agent Mail Backup Content
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" wrote in message
news:1A46B036-A6D5-4D0E-81A1-A7F887637A01@microsoft.com...
> Hi,
>
> I was wonderi
Fri, 14 Jan 2005 07:48:06 -0600
"Keith Kratochvil"
|
Re: Customizing Agent Mail Backup Content
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 suc
Fri, 14 Jan 2005 07:03:07 -0800
"=?Utf-8?B?TWljaGFlbA==?="
|
Re: Customizing Agent Mail Backup Content
Double-click on the job and look at the notification tab.
--
Keith
"Michael" wrote in message
news:84954ADC-9016-4860-99E6-5F6DDD5550B9@microsoft.com...
> 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 ex
Fri, 14 Jan 2005 10:09:29 -0600
"Keith Kratochvil"
|