Enabling jobs

• Howard C. BAchtel-438731

  SSCrazy

  Points: 2384

  More actions

  July 16, 2010 at 7:34 am

  #146295

  I have had a need to disable a string of jobs (source data not available) with different start and stop times during the non-business hours.

  When the source data is again available and I re-enable the jobs, should I expect all jobs to start at once because the "next scheduled date/time" has passed, or will it pick up the schedule from the enable time? If all at once, is there a programatic way to address this without manually changing the date parameter in the schedules?

  Also, how/where can I find the links to descriptions for the sys%% table columns (e.g. sysjobs, category_id)? This is a question for various individual items so a pointer to some documentation would be most helpful.

  Thanks in Advance.

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  July 16, 2010 at 8:12 am

  #1194132

  Hi

  The jobs will wait for the next scheduled time.

  Check books online or just enter the table name like sysjobs in Google.

  Here is just an example

  http://msdn.microsoft.com/en-us/library/ms187406.aspx

  Thank You,

  Best Regards,

  SQLBuddy.

• Howard C. BAchtel-438731

  SSCrazy

  Points: 2384

  More actions

  July 16, 2010 at 8:28 am

  #1194146

  Thanks. This will help a lot.

  I found the links and have built queries to get the information as needed.