Search

sp_get_sqlagent_properties doesnt return all the correct information by Marshall GSEIT

Active

1
0
Sign in
to vote
Type: Bug
ID: 778988
Opened: 2/11/2013 11:39:04 AM
Access Restriction: Public
0
Workaround(s)
1
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)

Product Language

English

Version

SQL Server 2008 R2 SP2 CTP

Category

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

Operating System

Windows 7 Professional

Operating System Language

US English

Steps to Reproduce

EXEC msdb.dbo.sp_get_sqlagent_properties;

Actual Results

email_profile = NULL

Expected Results

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

Platform

X64

Virtualization

 
File Attachments
0 attachments
Sign in to post a comment.
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
Sign in to post a workaround.