Hi All,
I have an FTP Server where the users are sending files (say the server
name is fs1). I was wondering whether there was a way to know every two
hours that the FTP server was up writing sql codes (SQL server is
running on a different server and the server name is dbs1). If it is
down (for any reasons) then I want to send mail to network personnel. I
want to put that code in a scheduled job to run every two hours.
Could any one please help what I can do in this situation?
Thanks a million in advance.
best regards,
mamunConsider using MOM for this:
http://www.microsoft.com/mom/default.mspx
David Portas
SQL Server MVP
--
Showing posts with label sending. Show all posts
Showing posts with label sending. Show all posts
Tuesday, March 27, 2012
Monday, March 12, 2012
Frequent SqlException
system.Data.SqlClient.SqlException: A transport-level error has occurred
when sending the request to the server. (provider: TCP Provider, error: 0 -
An existing connection was forcibly closed by the remote host.)
can you help with the above errorHi
You may want to look at tracing the data access at:
http://msdn2.microsoft.com/en-us/library/ms971550.aspx
Are you using connection pooling? It may be that you are trying to re-use a
connection that has been closed. You could try changing the keepalive
interval (in Configuration Manager) so it is less likely to be closed.
John
"Windows 2003 user" wrote:
> system.Data.SqlClient.SqlException: A transport-level error has occurred
> when sending the request to the server. (provider: TCP Provider, error: 0
-
> An existing connection was forcibly closed by the remote host.)
> can you help with the above error
when sending the request to the server. (provider: TCP Provider, error: 0 -
An existing connection was forcibly closed by the remote host.)
can you help with the above errorHi
You may want to look at tracing the data access at:
http://msdn2.microsoft.com/en-us/library/ms971550.aspx
Are you using connection pooling? It may be that you are trying to re-use a
connection that has been closed. You could try changing the keepalive
interval (in Configuration Manager) so it is less likely to be closed.
John
"Windows 2003 user" wrote:
> system.Data.SqlClient.SqlException: A transport-level error has occurred
> when sending the request to the server. (provider: TCP Provider, error: 0
-
> An existing connection was forcibly closed by the remote host.)
> can you help with the above error
Frequent SqlException
system.Data.SqlClient.SqlException: A transport-level error has occurred
when sending the request to the server. (provider: TCP Provider, error: 0 -
An existing connection was forcibly closed by the remote host.)
can you help with the above errorHi
You may want to look at tracing the data access at:
http://msdn2.microsoft.com/en-us/library/ms971550.aspx
Are you using connection pooling? It may be that you are trying to re-use a
connection that has been closed. You could try changing the keepalive
interval (in Configuration Manager) so it is less likely to be closed.
John
"Windows 2003 user" wrote:
> system.Data.SqlClient.SqlException: A transport-level error has occurred
> when sending the request to the server. (provider: TCP Provider, error: 0 -
> An existing connection was forcibly closed by the remote host.)
> can you help with the above error
when sending the request to the server. (provider: TCP Provider, error: 0 -
An existing connection was forcibly closed by the remote host.)
can you help with the above errorHi
You may want to look at tracing the data access at:
http://msdn2.microsoft.com/en-us/library/ms971550.aspx
Are you using connection pooling? It may be that you are trying to re-use a
connection that has been closed. You could try changing the keepalive
interval (in Configuration Manager) so it is less likely to be closed.
John
"Windows 2003 user" wrote:
> system.Data.SqlClient.SqlException: A transport-level error has occurred
> when sending the request to the server. (provider: TCP Provider, error: 0 -
> An existing connection was forcibly closed by the remote host.)
> can you help with the above error
Frequent SqlException
system.Data.SqlClient.SqlException: A transport-level error has occurred
when sending the request to the server. (provider: TCP Provider, error: 0 -
An existing connection was forcibly closed by the remote host.)
can you help with the above error
Hi
You may want to look at tracing the data access at:
http://msdn2.microsoft.com/en-us/library/ms971550.aspx
Are you using connection pooling? It may be that you are trying to re-use a
connection that has been closed. You could try changing the keepalive
interval (in Configuration Manager) so it is less likely to be closed.
John
"Windows 2003 user" wrote:
> system.Data.SqlClient.SqlException: A transport-level error has occurred
> when sending the request to the server. (provider: TCP Provider, error: 0 -
> An existing connection was forcibly closed by the remote host.)
> can you help with the above error
when sending the request to the server. (provider: TCP Provider, error: 0 -
An existing connection was forcibly closed by the remote host.)
can you help with the above error
Hi
You may want to look at tracing the data access at:
http://msdn2.microsoft.com/en-us/library/ms971550.aspx
Are you using connection pooling? It may be that you are trying to re-use a
connection that has been closed. You could try changing the keepalive
interval (in Configuration Manager) so it is less likely to be closed.
John
"Windows 2003 user" wrote:
> system.Data.SqlClient.SqlException: A transport-level error has occurred
> when sending the request to the server. (provider: TCP Provider, error: 0 -
> An existing connection was forcibly closed by the remote host.)
> can you help with the above error
Subscribe to:
Posts (Atom)