SQL server timed access URL activation data synchronization example

Time:2021-12-2

To create a job, execute the following command

exec master..XP_cmdshell ‘http://srm.rapoo.cn?op=sapintferace&i=1&t=1’

Activate and execute synchronization steps

The following is from the network and describes how to enable XP_ Cmdshell extended stored procedure commands

1、 Introduction
xp_ The cmdshell extended stored procedure executes the command string as an operating system command shell and returns all output as text lines.

3、 XP in SQL Server 2005_ cmdshell
Due to security risks, in SQL Server 2005, XP_ The cmdshell is closed by default.
At this point, if you execute XP_ The cmdshell will prompt that the service is not turned on:

exec xp_cmdshell ‘dir c:/’

Message 15281, level 16, status 1, process XP_ Cmdshell, line 1
SQL Server blocked access to component ‘XP’_ Procedure ‘sys.xp’ for cmdshell ‘_ Access to cmdshell ‘because this component has been turned off as part of the security configuration of this server. System administrators can use sp_ Configure enable ‘XP_ cmdshell’。 About enabling ‘XP’_ For details of cmdshell ‘, see “peripheral application configurator” in SQL Server Books Online.

4、 Open XP_ cmdshell

EXEC sp_configure ‘show advanced options’, 1;RECONFIGURE;EXEC sp_configure ‘xp_cmdshell’, 1;RECONFIGURE;
  
It’s the same as closing. Just change the “1” behind it to “0”
  
EXEC sp_configure ‘show advanced options’, 1;RECONFIGURE;EXEC sp_configure ‘xp_cmdshell’, 0;RECONFIGURE;

Failed to find stored procedure ‘Master.. XP’_ cmdshell’
Step 1: exec sp_ addextendedproc xp_ cmdshell,@dllname =’xplog70.dll’declare @o int
Step 2: execute sp_ addextendedproc ‘xp_ cmdshell’,’xpsql70.dll’