Set the timer task "go" using SQL Server 2005 jobs

Source: Internet
Author: User
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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.