Re: Send Report after Backup Runs? How?

From: Francesco Anti (fanti__at__sicosbt.it)
Date: 06/01/05 

Date: Wed, 1 Jun 2005 18:50:42 +0200

SQL Mail needs MAPI.
read http://tinyurl.com/btjq3 and its related links

Francesco Anti

"SUS Help" <bechtj@co.delaware.pa.us> wrote in message
news:%236L$7JsZFHA.2288@TK2MSFTNGP14.phx.gbl...
> As of right now I don't have Outlook installed. Is there a way to just
> point
> it to a SMTP Server and have the mail sent through that? Without having
> Outlook installed?
>
> "Francesco Anti" <fanti_@_sicosbt.it> wrote in message
> news:uvIN28rZFHA.3048@TK2MSFTNGP14.phx.gbl...
>> You must create a MAPI profile, for example using Outlook. Install it in
>> your server, then log on with the credentials under which SQL Server
>> Agent
>> runs (it must run under a domain account), and configure the profile
>> (from
>> Control Panel/Mail).
>> Right click Enterprise Manager\Management\SQL Server Agent, choose
>> "properties" and check if this profile is assigned to the mail profile.
>>
>> Francesco Anti
>>
>> "SUS Help" <bechtj@co.delaware.pa.us> wrote in message
>> news:O$nDXqrZFHA.3152@TK2MSFTNGP14.phx.gbl...
>> > Ok. I found out where I send the Notification. How does it use e-mail
>> > though? We have MS Exchange here, can I just add Outlook to the Server
> and
>> > have it send using Outlook?
>> >
>> >
>> > "Francesco Anti" <fanti_@_sicosbt.it> wrote in message
>> > news:ed7E2RrZFHA.2664@TK2MSFTNGP15.phx.gbl...
>> >> You can edit your SQL Server Agent Job that performs the backup
> activity,
>> > go
>> >> to Notifications tab and select the appropriate settings.
>> >> Refer to BOL ("Configuring Mail Profiles") about setting up a MAPI
>> >> profile
>> >> for SQL server Agent.
>> >>
>> >> Francesco Anti
>> >>
>> >> "SUS Help" <bechtj@co.delaware.pa.us> wrote in message
>> >> news:Oo4PH$qZFHA.980@TK2MSFTNGP12.phx.gbl...
>> >> >I have backups being done by SQL every night. How can I, or how do I
>> >> >have
>> >> > SQL send a report to my e-mail stating the backup ran successfully.
> Is
>> > it
>> >> > possible and if so can you explain how?
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>>
>
>

Quantcast