Hi,
The folowing is the scenario with which we are planning to utilize the CLR integration features in SQL Server 2005.
1. I've a WebService for sending E-mails (SMTP).
2. I've built and deployed a SQL Server Project and which has a SQLFunction as Mail.
3. I've added the WebReference in the SQL Server Project, which will enable me to send the emails.
(The SQL function uses the WebMethod for sending mails)
4. I've created a JOB scheduler in Yukon, which will execute a Stored Procedure every 10 mins. This Store Proc nvokes SQL Function which inturn uses the
Web Services to send the mail.
5.The stored procedure will invoke the SQL function.
The system is throwing an exception as follows,
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Executed as user: NT AUTHORITY\SYSTEM. A .NET Framework error occurred during execution of user defined routine or aggregate 'Mail': System.Net.WebException: The operation has timed-out.
at System.Net.HttpWebRequest.CheckFinalStatus(Boolean mustThrow)
at System.Net.HttpWebRequest.GetResponse()
at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request)
at System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRequest request)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at SQLServerProject.BAMMail.wsBAM_Mailer.SendMa. [SQLSTATE 42000] (Error 6522).
The step failed.
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Please help me to know where i have gone Wrong.
Please give details of Forums or Message Boards where we can post our queries on Yukon.
Thanks in Advance.
vikramshankar