What is sql server agent

Facebook, MySpace, and Twitter are all good examples of using technology to let I've got a few more thoughts on the topic this week, and I look forward to your comments. It runs as a Windows service and starts automatically when the system boots.

It basically performs the backup task, handles reporting services, log shipping, and user tasks like; T-SQL scheduling, etc. It also supports operators and alerts for administrator notification. It runs a job on schedule according to a specific event and on demand. The SQL Server agent uses the following types of components to perform its tasks. It defines the tasks that is to be performed and when to perform it. Job is performed on particular tasks that can be run multiple times.

By: Justin Stoltzfus Contributor, Reviewer. By: Satish Balakrishnan. Dictionary Dictionary Term of the Day. Machine Intelligence. Techopedia Terms. Connect with us. Once the jobs are executed, you can view the history if the execution was successful or failed. In case of a failure, there is an option to restart the job manually. There are a few components of the SQL Server Agent service that you must be aware of before proceeding forward.

Now that we have some idea about the SQL Server Agent, let us now go ahead and start the service if not already done. In my machine, the service is currently not running, and I am going to start it from scratch. You can follow the steps below to start the agent service on your machine. Head over to Run and type the command services. Click OK once done. Once you hit OK , the Services window will show up. As you can see in the figure below, the status of the service is not running.

Let us go and start the service. It might take a while to start the service. Once the service has started, the status will change to Running. Now that our agent service is up and running, let us create our first job using the graphical user interface.

We can also create jobs using T-SQL scripts; however, it is out of scope for this article and will be covered in some later articles. This blog post will show you how to enable this service. On the Properties Window , select an appropriate account. I will use the Local System account for my example. Then click on the Service tab. If you have any questions, please feel free to contact me at GarthMJ.