SQL Server timed access url Activation Data Synchronization example

Create a job and execute the following command:

Exec master .. xp_mongoshell 'HTTP: // srm.rapoo.cn? Op = sapintferace & I = 1 & t = 1'

Activate and execute synchronization steps

The following describes how to enable xp_mongoshell to extend the Stored Procedure commands.

I. Introduction
The xp_cmdshell extended stored procedure uses the command string as the operating system command shell for execution and returns all the output in the form of text lines.

Iii. xp_cmdshell in SQL Server 2005
Due to security risks, xp_cmdshell is disabled in SQL Server 2005 by default.
If xp_cmdshell is executed, the system prompts that the service is not enabled:

Exec xp_cmdshell 'dir c :/'

Message 15281, level 16, status 1, process xp_cmdshell, 1st rows
SQL Server blocks access to 'sys. xp_mongoshell' during the 'xp _ mongoshell' process, because this component has been disabled as part of the Server's security configuration. The system administrator can enable 'xp _ javasshell' by using sp_configure '. For more information about enabling 'xp _ external shell', see "peripheral application configurator" in SQL Server books online ".

4. Enable xp_mongoshell

EXEC sp_configure 'show advanced options', 1; RECONFIGURE; EXEC sp_configure 'xp _ Your shell', 1; RECONFIGURE;
　　
Close the same. Just change the "1" behind the above to "0.
　　
EXEC sp_configure 'show advanced options', 1; RECONFIGURE; EXEC sp_configure 'xp _ cmdshell', 0; RECONFIGURE;

Unable to find the Stored Procedure 'master .. xp_mongoshell'
Step 1: Execute EXEC sp_addextendedproc xp_cmdshell, @ dllname = 'xplog70. dll 'declare @ o int
Step 2: Execute sp_addextendedproc 'xp _ cmdshell', 'sql70. dll'