SQL Server Agent - won't start a scheduled, recurring job

• rgodwin

  Newbie

  Points: 4

  More actions

  October 8, 2009 at 11:29 am

  #210753

  I have a package that moves data from one server to another. When I schedule it to run once, it works fine. However, when I schedule it as a recurring job, it never starts. Viewing the job history confirms this.

  Any help is appreciated.

  ---------------
  Randy Godwin

• Shawn Melton

  SSC-Insane

  Points: 24685

  More actions

  October 8, 2009 at 11:45 am

  #1063638

  Do you see any errors?

  Shawn Melton
  Twitter: @wsmelton
  Blog: wsmelton.github.com
  Github: wsmelton

• rgodwin

  Newbie

  Points: 4

  More actions

  October 8, 2009 at 11:48 am

  #1063640

  The server agent never starts the job.

  ---------------
  Randy Godwin

• rgodwin

  Newbie

  Points: 4

  More actions

  October 8, 2009 at 12:47 pm

  #1063670

  I'm not sure if I found the solution or just worked around the problem. I ended up changing the "Daily Frequency" as illustrated below.

  THIS DIDN'T WORK

  

  THIS WORKED

  

  ---------------
  Randy Godwin