SQL Server timed Access URL activation data synchronization

To create a job, execute the following command

EXEC master. xp_cmdshell ' Http://srm.rapoo.cn?op=sapintferace&i=1&t=1 '

Activate to perform a synchronous network step

The following is from the network, which describes how to enable the xp_cmdshell extended stored procedure to command

First, Introduction
The xp_cmdshell extended stored procedure executes the command string as the operating system command shell and returns all output as a text line.


Iii. xp_cmdshell in SQL Server 2005
Because of the security implications, xp_cmdshell is turned off by default in SQL Server 2005.
At this point, if you execute xp_cmdshell you will be prompted that the service is not turned on:

exec xp_cmdshell ' dir c:/'

Msg 15281, Level 16, State 1, procedure xp_cmdshell, line 1th
SQL Server blocked access to the process ' Sys.xp_cmdshell ' of component ' xp_cmdshell ' because this component was shut down as part of this server's security configuration. System administrators can enable ' xp_cmdshell ' by using sp_configure. For more information about enabling ' xp_cmdshell ', see "surface area Configurator" in SQL Server Books Online.

Four, open xp_cmdshell

EXEC sp_configure ' show advanced options ', 1; RECONFIGURE; EXEC sp_configure ' xp_cmdshell ', 1; RECONFIGURE;
　　
Closed. Just change the "1" on the back of the top to "0".
　　
EXEC sp_configure ' show advanced options ', 1; RECONFIGURE; EXEC sp_configure ' xp_cmdshell ', 0; RECONFIGURE;

The stored procedure ' master ' could not be found. xp_cmdshell '
First step: EXEC sp_addextendedproc xp_cmdshell, @dllname = ' xplog70.dll ' declare @o int
Step two: Sp_addextendedproc ' xp_cmdshell ', ' Xpsql70.dll '