August 23, 2006 at 9:07 am
I have a unique situation. I have implemented a rather sophisticated notification system within our production servers that sends an email when certain jobs fail. I have a Blackberry that's keyed to my Outlook and everything has worked fine. However, I've recently moved to an area where I do not get ANY cell reception. As a quick fix I've resorted to setting up my laptop by the bed and using VPN to connect to our network then keep Outlook up all night. This isn't 100% fail-proof since the VPN connection times out sometimes. Does anyone know a way to have SQL Server call a LAND line?
August 24, 2006 at 4:10 pm
This might work, if xp_cmdshell is enabled.
exec master.dbo.xp_cmdshell('rasdial entryname')
WAITFOR DELAY '00:03:00'
exec master.dbo.xp_cmdshell('rasdial entryname /disconnect')
Another way would be to write an XP in C which calls RasDial. Like this:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q171366&
This looks interesting, if you would rather create a CLR assembly with a CLR function:
http://www.pcreview.co.uk/forums/thread-1416393.php
"I just finished creating a RAS wrapper for .NET with (hopefully) all RAS
functionality built in for outgoing connections. It can be found at:"
--> http://www.gotdotnet.com/Workspaces/Workspace.aspx?id=dd3ebd3e-684a-4dde-a843-e5fdb0895b8e
August 25, 2006 at 8:37 am
At one place i worked at, we had a web page that displayed the status of things. A simple red, amber, green traffic light was displayed on a grid for the status of a zillion processes. Red for failure, amber for running, and green for succeeded last processing. The web page was set to refresh every 60 seconds and you could drill down on the lights to get details for each process.
August 25, 2006 at 11:26 am
Can you explain more about RASDIAL and it's use? I've never seen that before?
Thanks,
dab
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply