what is the effect of job category

• bassem_farouk

  SSC Journeyman

  Points: 90

  More actions

  October 6, 2010 at 6:49 pm

  #97597

  Hi

  what is the different if i make my sqlserver agent job as a realtime or daemon or uncategorized in sq 2000?

  if i have the job runs every 1 hour so is realtime will force the job to exit if it runs for more than 1 hour?

  Thanks in advance

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  October 6, 2010 at 10:39 pm

  #1233253

  Job Categories help you organize the jobs for easy management. They do not have any impact on the job execution.

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga

• bassem_farouk

  SSC Journeyman

  Points: 90

  More actions

  October 7, 2010 at 1:17 am

  #1233284

  very useful info , i did not find it anywhere !

  thank you