Hi,

I found out that I can only send mail under my own profile. How can I make my
profile public so that anyone that access to the sql server can send the
email?

Besides, I want to make it scheduled on batch job purposes.

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...erver/200805/1

In SSMS, go to Management node and right click on Database Mail and click
Configure Database Mail.

In the Select Configuration Task window, choose Manage profile security and
click Next.

You'll see the Public and Private Profile tabs there. In the Public Profile
tab, choose a profile as your public profile by checking Public field in the
list and also you may want to set it as your Default Profile.

To use this profile in your jobs, you should create an Operator. And then
you should configure your job to use this Operator to send an email in case
of a successful\failed\both situation. Do not forget to configure the SQL
Server Agent to enable this profile (from the Alert System menu)

--
Ekrem Önsoy



"honeybee86 via SQLMonster.com" <u43452@uwe> wrote in message
news:842da78db9bf8@uwe...
> Hi,
>
> I found out that I can only send mail under my own profile. How can I make
> my
> profile public so that anyone that access to the sql server can send the
> email?
>
> Besides, I want to make it scheduled on batch job purposes.
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums...erver/200805/1
>

Gte it done. Weird thing I didnt do any configuration on the Job on
additional configuration on database mail but it can auto run for me. I guess
that is all. Thanks

Ekrem Önsoy wrote:
>In SSMS, go to Management node and right click on Database Mail and click
>Configure Database Mail.
>
>In the Select Configuration Task window, choose Manage profile security and
>click Next.
>
>You'll see the Public and Private Profile tabs there. In the Public Profile
>tab, choose a profile as your public profile by checking Public field in the
>list and also you may want to set it as your Default Profile.
>
>To use this profile in your jobs, you should create an Operator. And then
>you should configure your job to use this Operator to send an email in case
>of a successful\failed\both situation. Do not forget to configure the SQL
>Server Agent to enable this profile (from the Alert System menu)
>
>> Hi,
>>
>[quoted text clipped - 4 lines]
>>
>> Besides, I want to make it scheduled on batch job purposes.

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...erver/200805/1