1. Turn on the SQL Server Agent service
Using a job requires support for the SQL Agent service and needs to be set to start automatically, otherwise your job will not be executed.
The following steps open the service: Start-->>> run-->>> enter "Services.msc"-->>> enter the service, turn on the SQL Server Agent service, and set to Automatic.
:
2. New Job
Click "SQL Server Agent", "right click Job", select "New Job"
3. Set the name and description of the new job
4. Set up a task's execution steps
Select the "Step" option and click "New" to add the first step: Insert the data and click "OK".
We can also create new steps and make more settings in the Advanced Options dialog box in the new step. ()
5. Set up the execution plan
Select schedule options, new schedule
Configure the direct schedule as needed:
Click OK to make sure our plan is complete: the statement that inserts the data starts on March 8, 2012, executes hourly, and in the new Job dialog we have the option not set, but this is not necessary, you can do the relevant settings according to the specific situation.
Set the timer task "go" using SQL Server 2005 jobs