SqlServer Agent Job

• jqueryone

  Grasshopper

  Points: 20

  More actions

  April 3, 2009 at 6:46 am

  #198963

  Hi friends,

  I have a problem about sql server 2008 agent job. My job agent is running 5 minutes everday;

  Example , 11.20.00 AM next running time 11.20.05...11.20.10....11.20.15 etc...

  But, sometimes running one second or several second (example, 11.20.00 next 11.20.01 next 11.20.04 etc..) this running is error. Sometimes, some many recording(11.30.00...next..11.30.00..next...11.30.00) Why ?

  I want to this job is recurring 5 minutes...

  Please help me friends..

  Thank you.

• Jerry Hung

  SSChampion

  Points: 12968

  More actions

  April 3, 2009 at 8:08 am

  #971586

  Not entirely sure what you meant

  Your job schedule is set to DAILY, and EVERY 5 MINUTES, between 12:00:00 AM and 11:59:59 PM ?

  SQLServerNewbieMCITP: Database Administrator SQL Server 2005

• jqueryone

  Grasshopper

  Points: 20

  More actions

  April 3, 2009 at 12:12 pm

  #971758

  Yes Jerry, this correct. What is the problem according to you ?

  Thank you...