SQL Server timed access URL activates data synchronization sample _mssql

Create a job, execute the following command

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

To activate the Perform sync network step

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

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

Iii. xp_cmdshell in SQL Server 2005
Because of a security risk, xp_cmdshell is turned off by default in SQL Server 2005.
At this point, if the execution xp_cmdshell will prompt the service is not turned on:

exec xp_cmdshell ' dir c:/'

Message 15281, Level 16, State 1, Process xp_cmdshell, line 1th
SQL Server blocked access to the process ' Sys.xp_cmdshell ' of component ' xp_cmdshell ' because this component has been shut down as part of this server security configuration. System administrators can enable ' xp_cmdshell ' by using sp_configure. For more information about enabling ' xp_cmdshell ', see "Perimeter Configuration" in SQL Server Books Online.

Four, open xp_cmdshell

EXEC sp_configure ' show advanced options ', 1; Reconfigure; EXEC sp_configure ' xp_cmdshell ', 1; Reconfigure;
　　
Close. 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;

Could not find stored procedure ' master ... xp_cmdshell '
First step execution: EXEC sp_addextendedproc xp_cmdshell, @dllname = ' xplog70.dll ' declare @o int
Step two: Sp_addextendedproc ' xp_cmdshell ', ' Xpsql70.dll '