Post reply

Output from sp_help_jobSchedule

  • October 3, 2006 at 7:53 am

    #367516

    Hi All

    When I run the proc sp_help_jobSchedule, I get back such columns as freq_type,freq_interval,freq_subday_type,freq_subday_interval.

    Is there a system lookup table that will describe what these types are.

    I am basically trying to write some report about our job scheduling and dependencies.

    Any insight would be appreciated.

    Thanks

    Michael.

  • October 3, 2006 at 8:11 am

    #663841

    Michael

    You will find a table with the meanings of the columns in Books Online.  For your report, I think you will need to create your own lookup tables with this information, or use CASE statements.

    John

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

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