Determining how long a SQL Job takes

  • Easy question, and I'm sure the answer is equally easy. We're getting ready to move our agency, and thus our servers, in a few days. Before we shut the servers off I want to run the full server backup SQL Job. In order to know how much time I'll need, do all I have to do is look at the history of the job in SQL Server Agent?

    Kindest Regards, Rod Connect with me on LinkedIn.

  • If that single job backs up everything you need, and the databases haven't grown significantly since the last backup, then, yes, the Run Duration from the job history should be roughly the amount of time you need.

  • I hope you're running backups every day right now.

  • homebrew01 (9/28/2009)


    I hope you're running backups every day right now.

    We are.

    Kindest Regards, Rod Connect with me on LinkedIn.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply