Home Dashboard Directory Help

sp_get_sqlagent_properties doesnt return all the correct information by Marshall GSEIT


 as By Design Help for as By Design

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

Sign in to post a comment.
Posted by Marshall GSEIT on 11/6/2013 at 12:38 PM
sp_get_sqlagent_properties is _not_ working "By Design".

It is clear when looking at what this sp returns, that some fields are returned, e.g. email_profile, but a value is never provided.

In addition, when you look at the contents of sp_get_sqlagent_properties by selecting "Modify" from the Object Explorer; code is obviously there and is intended to return this information. sp_get_sqlagent_properties just fails to do so.

I can see no evidence for marking this as "By Design".
Posted by Microsoft on 10/18/2013 at 9:44 AM
Hello Marshall.

You should be able to view the properties through the UI. There is no SP available for DBMail.
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.

Sethu Srinivasan [MSFT]
SQL Server
Sign in to post a workaround.