• Hi,

    I do this in my index rebuild job by having a variable that stores the start time of the job. Then a while loop that runs through my indexes, but the condition on the loop says only process an index if the current time is less than 10 hours after the start time.

    The other way you could do it is to use EXEC [msdb].[dbo].[sp_start_job] with a job name, scheduled to run 10 hours after your other job starts.

    Simon



    MCSE: Data Platform
    MCSE: Business Intelligence
    Follow me on Twitter: @WazzTheBadger
    LinkedIn Profile: Simon Osborne