sp_get_sqlagent_properties doesnt return all the correct information by Marshall GSEIT

Active

Type:	Bug
ID:	778988
Opened:	2/11/2013 11:39:04 AM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

When running EXEC msdb.dbo.sp_get_sqlagent_properties
not all of the information is being returned. E.g. email_profile.

Details (expand)

English

SQL Server 2008 R2 SP2 CTP

Tools (SSMS, Agent, Profiler, Migration, etc.)

Windows 7 Professional

US English

EXEC msdb.dbo.sp_get_sqlagent_properties;

email_profile = NULL

Same as that listed when running:
EXECUTE msdb.dbo.sysmail_help_profile_sp;

X64

0 attachments

Posted by Marshall GSEIT on 3/12/2013 at 1:05 PM

Yes, there is an associated Mail profile. The profile has an SMTP account assigned to it. I have verified this is working correctly with a test email.

Instead of using sp_get_sqlagent_properties; what should I use to retrieve the properties of the SQL Agent?

Posted by Microsoft on 3/12/2013 at 8:25 AM

Hello Marshall. This topic has remained inactive for an extended period and will be cleaned up. If you find this is being done in error, simply start a new thread and share relevant information and it will be addressed directly. -Walter A Jokiel, Program Manager, SQL Server

Posted by Sethu Srinivasan on 2/13/2013 at 11:41 AM

Hello Marshall,
Can you check if SQLAgent's notification setting has an associated Database Mail profile?. Could you add more detaisl you the scenario you are working on?

sp_get_sqlagent_properties is not a documented procedure. It is recommended not to rely on undocumented stored procedures in your application.

Thanks
Sethu Srinivasan [MSFT]
SQL Server

Microsoft