when did msdb.dbo.sp_set_sqlagent_properties change to use @databaseemail_profile ?

Question

when did msdb.dbo.sp_set_sqlagent_properties change to use @databaseemail_profile ?

winston Smith

SSCoach

Points: 19498
More actions
August 6, 2014 at 5:03 am

#310547

on my sql 2014 server i can execute the following without issue:
EXEC msdb.dbo.sp_set_sqlagent_properties
@email_save_in_sent_folder=1,
@databasemail_profile=N'DB Alert'
[/codel]
On my 2008 R2 server this doesnt work though, and tells me the @databaseemail_profile parameter is not valid.
On my 2005 server the same action, when scripted tries to modify the registry.
When did this change to use @databaseemail_profile?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

HanShi SSC-Dedicated Points: 33506 More actions · Answer 1

winston Smith (8/6/2014)
on my sql 2014 server i can execute the following without issue:
EXEC msdb.dbo.sp_set_sqlagent_properties
@email_save_in_sent_folder=1,
@databasemail_profile=N'DB Alert'
[/codel]
On my 2008 R2 server this doesnt work though, and tells me the @databaseemail_profile parameter is not valid.
....

This doen't sound like the procedure has changed, but more like your mail profile on the SQL2008 instance has a different name or doesn't exist.

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Robert Klimes SSCoach Points: 17865 More actions · Answer 2

It was added in SQL Server 2012

Bob
-----------------------------------------------------------------------------
How to post to get the best help[/url]

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 3

Dear Folks,

I did more research on this.

For SQL 2008 R2 and below, use "@email_profile" instead of "@databasemail_profile", but from sql 2012 onwards +, you can use "@databasemail_profile".

Let me know if this works.

Thanks.