Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Configure mail settings to send e-mail in dts

Status
Not open for further replies.

AnaFlor

Programmer
Mar 17, 2004
65
PT
Hello,

When I try to associate an e-mail profile in the properties of sql server agent it is giving me the following error:

Could not find stored procedure 'msdb.dbo.sp_set_sqlagent_propoerties'.

Do you know what is the problem? Can you help me solving this?

Thanks
 
sp_set_sqlagent_propoerties is a user defined stored procedure. It doesnt exist in the database where you execute.
 
But then, where can I find it?
Because we didn't create any stored procedure in any machine, and in any database.

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top