"Internet of Things applications and maintenance" database timing processing based on SQL Sever R2

--SQLServer : --1. Open Sql server management studio, and in the Object Explorer list, select SQL  server  agent "; --2. Mouse right-click on" sql server  Agent ", select" Start (S) ", if started, you can omit this step; --3. Expand the sql server  proxy list, right-click jobs and new job; --3.1   in the General tab: --        Enter the job name, such as" My Job "; --3.2   in the" Steps "tab: --3.2.1  Click" New ", enter" step name ", such as" Step 1 ", type the default T-SQL script, you can also select SSIS package, etc. --3.2.2  Select the database you want to work with in the database column, enter the SQL code to execute in the blank edit bar on the right side of the command,         --       can also click" Open "under the command to open the. SQL script; --3.2.3  input run script, it is recommended to click" Analysis "to ensure that the script syntax is correct, and then click the" OK "button below; --3.3   in the Schedule tab: --3.3.1  Click" New ", enter" plan name ", such as" Plan 1 ", the plan type default is" Repeat Execution ", you can also choose to perform once; --3.3.2  select" Daily "," weekly "or" monthly "at" Frequency "and" execution ", taking" daily "as an example, the interval time input interval is executed once a few days, --       below you can also choose to perform one-time or interval-by-day recurrence --3.3.3  in duration Select the start date and due date for the scheduled execution, and then click the OK button;         --Note to set the service to start automatically, or the job will not run after restarting the server. --How to start the Proxy service: --start-up and run-input services.msc--> find the service for the sql server  agent and double-click Startup type Select Automatic and OK   

"Internet of Things applications and maintenance" database timing processing based on SQL Sever R2