Post reply

Next Run Time for Scheduled Job

  • April 27, 2007 at 11:22 am

    #177542

    Hi Folks,

    It is simple question but i could not locate it. Like 2000 where I can see next run time option for the Scheduled Job? I went through every part of properties of schedules job but no luck.

    Thanks in advance

    SqlIndia

  • April 27, 2007 at 11:27 am

    #703014

    One spot where you can view that info is in the Job Activity Monitor.  You'll find a 'Next Run' column there.

  • April 29, 2007 at 10:12 pm

    #703192

    and here's how Job Activity Monitor figures it out:

    exec

    msdb.dbo.sp_help_job

    ---------------------------------------
    elsasoft.org

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply