Does anyone know how often the sysjobschedules table is updated?

Hi,
I'm trynig to write some simple code to check that all of my scheduled jobs have completed (successfully or not) by checking that the next run date and time for the active schedules is in the future. However when doing this the sysjobschedules tables
does not seem to update with the next information immediately. Does anynoe know of the frequency of this update or what controls it?
Cheers,
John
You might want to take a look at sp_help_job instead.
Andrew J. Kelly SQL MVP
"John" <j.edwards@.ausbulk.com.au> wrote in message
news:413AE3B6-4491-42AE-9412-4025D74764A6@.microsoft.com...
> Hi,
> I'm trynig to write some simple code to check that all of my scheduled
jobs have completed (successfully or not) by checking that the next run date
and time for the active schedules is in the future. However when doing this
the sysjobschedules tables does not seem to update with the next information
immediately. Does anynoe know of the frequency of this update or what
controls it?
> Cheers,
> John

Does anyone know how often the sysjobschedules table is updated?

Hi,
I'm trynig to write some simple code to check that all of my scheduled jobs
have completed (successfully or not) by checking that the next run date and
time for the active schedules is in the future. However when doing this the
sysjobschedules tables
does not seem to update with the next information immediately. Does anynoe
know of the frequency of this update or what controls it?
Cheers,
JohnYou might want to take a look at sp_help_job instead.
Andrew J. Kelly SQL MVP
"John" <j.edwards@.ausbulk.com.au> wrote in message
news:413AE3B6-4491-42AE-9412-4025D74764A6@.microsoft.com...
> Hi,
> I'm trynig to write some simple code to check that all of my scheduled
jobs have completed (successfully or not) by checking that the next run date
and time for the active schedules is in the future. However when doing this
the sysjobschedules tables does not seem to update with the next information
immediately. Does anynoe know of the frequency of this update or what
controls it?
> Cheers,
> John

Does anyone know how often the sysjobschedules table is updated?

Hi
I'm trynig to write some simple code to check that all of my scheduled jobs have completed (successfully or not) by checking that the next run date and time for the active schedules is in the future. However when doing this the sysjobschedules tables does not seem to update with the next information immediately. Does anynoe know of the frequency of this update or what controls it
Cheers
JohnYou might want to take a look at sp_help_job instead.
--
Andrew J. Kelly SQL MVP
"John" <j.edwards@.ausbulk.com.au> wrote in message
news:413AE3B6-4491-42AE-9412-4025D74764A6@.microsoft.com...
> Hi,
> I'm trynig to write some simple code to check that all of my scheduled
jobs have completed (successfully or not) by checking that the next run date
and time for the active schedules is in the future. However when doing this
the sysjobschedules tables does not seem to update with the next information
immediately. Does anynoe know of the frequency of this update or what
controls it?
> Cheers,
> John