Welcome to PC Teach Me...

Free Computer Training Videos.

Although you do not need to register to access this site. Registering has its benefits. Such as:

  • Access to training material associated with the video you are watching [if applicable]
  • Automatic email updates when new training videos are available.
  • Ask for a training video.
  • Exclusive access to pose questions to me [limited availability as I am doing this for free :-)].
  • Free contribution of your own training topics, this includes referencing your videos outside of PC Teach Me.
  • Its Free!

Member Login

Lost your password?

Not a member yet? Sign Up!

By registering with this blog you are also agreeing to receive email notifications for new posts but you can unsubscribe at anytime.

25425 Registered Users
71 Number Of Articles
Free Video Tutorials (Email) Free Video Tutorials (RSS) Free Video Tutorials (Twitter) Free Video Tutorials (Flickr)

SQL: Server Agent

Part of Microsoft SQL Intermediate

sql SQL: Server Agent SQL: Server Agent

After you have your database the way you want it, the next thing on your list of priorities should be maintenance.  You can perform most things manually in SQL, but what if you wanted the server to do it? Well, this is where the SQL Server Agent comes in.

Maintenance And Scheduling Of SQL

The SQL Server Agent is a service,  that (if configured) is an “always on” service which runs specific commands at predetermined points in the day.  The most classic example of the Server Agent is backups,  you will generally want to backup the database/system last thing at night.   To do this you would create a “job”.  Sounds simple? …well it is.  However, there are other things to consider like what happens if it fails?  Do you want the agent to try again?  Do you want the agent to notify you of the error? If so, how?

Yep, there is quite a lot of things we take for granted that the Server Agent needs to be configured for.  Now this makes it sound like its complicated,  the great thing about the Server Agent is it’s as easy or complex as you would like to make it.  Not to mention that maintenance plans which are in SQL Server (covered in another post) also perform the steps of setting up the Server Agent for you.  However, slightly going off topic.

All these things are possible with the Server Agent.   This brief video will explain the basics of the agent but will take a while to master all of its capabilities. As already discussed a subsequent video will be available to deal specifically with maintenance plans (such as database backups etc…).

So sit back and watch this video about the basics which will get covered in more depth on subsequent tutorials.

More SQL Videos

This video is one of many SQL tutorials on this site click here for more

Related Posts

192 Comments

  1. David says
    25 Sep 14 at 3:51pm

    Good video, nice to get a quick overview with a few nuggets of useful information. Not bad for 10 minutes. Thanks again.

  2. 08 Aug 13 at 10:43pm

    Thanks for ones marvelous posting! I certainly enjoyed
    reading it, you might be a great author. I will make certain to bookmark your blog and
    will eventually come back from now on. I want to encourage you to definitely continue your great writing, have
    a nice weekend!

  3. beeilve says
    17 May 13 at 1:35pm

    Hi Jon, thanks for making these videos. They are fantastic. I’m sad to see that this was uploaded in 2010. I hope you eventually return to this series!

  4. PCTeachME says
    18 Apr 11 at 12:14pm

    Hi, A very good question. Proactive manual maintenance is something we should always strive for & your suggestion (IMO) is the best way. But consider other factors such as DBA workload & server disk space capacity (in the video example) sometimes means we need to use the agent to do jobs for us when we are not available. For example, I have a development environment which is always low on disk space & when I need to perform a warehouse rebuild I would be stumped if it was not there.

  5. PCTeachME says
    18 Apr 11 at 12:14pm

    [..YouTube..] Hi, A very good question. Proactive manual maintenance is something we should always strive for & your suggestion (IMO) is the best way. But consider other factors such as DBA workload & server disk space capacity (in the video example) sometimes means we need to use the agent to do jobs for us when we are not available. For example, I have a development environment which is always low on disk space & when I need to perform a warehouse rebuild I would be stumped if it was not there.

  6. PCTeachME says
    18 Apr 11 at 12:14pm

    [..YouTube..] @sadgreen Hi, A very good question. Proactive manual maintenance is something we should always strive for & your suggestion (IMO) is the best way. But consider other factors such as DBA workload & server disk space capacity (in the video example) sometimes means we need to use the agent to do jobs for us when we are not available. For example, I have a development environment which is always low on disk space & when I need to perform a warehouse rebuild I would be stumped if it was not there.

  7. PCTeachME says
    18 Apr 11 at 12:14pm

    @sadgreen Hi, A very good question. Proactive manual maintenance is something we should always strive for & your suggestion (IMO) is the best way. But consider other factors such as DBA workload & server disk space capacity (in the video example) sometimes means we need to use the agent to do jobs for us when we are not available. For example, I have a development environment which is always low on disk space & when I need to perform a warehouse rebuild I would be stumped if it was not there.

  8. PCTeachME says
    18 Apr 11 at 12:14pm

    @sadgreen Hi, A very good question. Proactive manual maintenance is something we should always strive for & your suggestion (IMO) is the best way. But consider other factors such as DBA workload & server disk space capacity (in the video example) sometimes means we need to use the agent to do jobs for us when we are not available. For example, I have a development environment which is always low on disk space & when I need to perform a warehouse rebuild I would be stumped if it was not there.

  9. PCTeachME says
    18 Apr 11 at 12:14pm

    @sadgreen Hi, A very good question. Proactive manual maintenance is something we should always strive for & your suggestion (IMO) is the best way. But consider other factors such as DBA workload & server disk space capacity (in the video example) sometimes means we need to use the agent to do jobs for us when we are not available. For example, I have a development environment which is always low on disk space & when I need to perform a warehouse rebuild I would be stumped if it was not there.

  10. PCTeachME says
    18 Apr 11 at 12:14pm

    @sadgreen Hi, A very good question. Proactive manual maintenance is something we should always strive for & your suggestion (IMO) is the best way. But consider other factors such as DBA workload & server disk space capacity (in the video example) sometimes means we need to use the agent to do jobs for us when we are not available. For example, I have a development environment which is always low on disk space & when I need to perform a warehouse rebuild I would be stumped if it was not there.

  11. PCTeachME says
    18 Apr 11 at 12:14pm

    @sadgreen Hi, A very good question. Proactive manual maintenance is something we should always strive for & your suggestion (IMO) is the best way. But consider other factors such as DBA workload & server disk space capacity (in the video example) sometimes means we need to use the agent to do jobs for us when we are not available. For example, I have a development environment which is always low on disk space & when I need to perform a warehouse rebuild I would be stumped if it was not there.

  12. PCTeachME says
    18 Apr 11 at 12:14pm

    @sadgreen Hi, A very good question. Proactive manual maintenance is something we should always strive for & your suggestion (IMO) is the best way. But consider other factors such as DBA workload & server disk space capacity (in the video example) sometimes means we need to use the agent to do jobs for us when we are not available. For example, I have a development environment which is always low on disk space & when I need to perform a warehouse rebuild I would be stumped if it was not there.

1 8 9 10

Leave a Comment

You must be logged in to post a comment.

Valid XHTML 1.0 Transitional website security