Post reply

Job Schedule information

  • October 7, 2009 at 3:06 am

    #95999

    Hi there,

    There's a job in Agent that from what I can see runs at 12am. However, there's a couple fo things I'm not sure about. The @freq_subday_type is at 4 and @freq_subday_interval is 15. What does that mean? (the full schedule is below)

    Does the job run once a day at 12 or is it running more than that etc?

    Hope someone can help.

    Thanks

    @enabled=1,

    @freq_type=4,

    @freq_interval=1,

    @freq_subday_type=4,

    @freq_subday_interval=15,

    @freq_relative_interval=0,

    @freq_recurrence_factor=0,

    @active_start_date=20080912,

    @active_end_date=99991231,

    @active_start_time=0,

    @active_end_time=235959

  • October 7, 2009 at 3:15 am

    #1062644

    cidr (10/7/2009)

    Hi there,

    There's a job in Agent that from what I can see runs at 12am. However, there's a couple fo things I'm not sure about. The @freq_subday_type is at 4 and @freq_subday_interval is 15. What does that mean? (the full schedule is below)

    Does the job run once a day at 12 or is it running more than that etc?

    Hope someone can help.

    Thanks

    @enabled=1,

    @freq_type=4,

    @freq_interval=1,

    @freq_subday_type=4,

    @freq_subday_interval=15,

    @freq_relative_interval=0,

    @freq_recurrence_factor=0,

    @active_start_date=20080912,

    @active_end_date=99991231,

    @active_start_time=0,

    @active_end_time=235959

    Ok, Created a job with the same details as you have supplied.

    Occurs every day every 15 minutes between 00:00:00 and 23:59:00, schedule will be used starting on 12/09/2008

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • October 7, 2009 at 3:17 am

    #1062645

    Thanks for responding. So, just to clarify, that's every 15 minutes all day?

    Thanks

  • October 7, 2009 at 3:21 am

    #1062647

    yep that means it will run the job every 15 minutes between the times specified every day and that includes the weekends

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • October 7, 2009 at 9:36 am

    #1062880

    cidr (10/7/2009)

    Hi there,

    @enabled=1,

    @freq_type=4,

    @freq_interval=1,

    @freq_subday_type=4,

    @freq_subday_interval=15,

    @freq_relative_interval=0,

    @freq_recurrence_factor=0,

    @active_start_date=20080912,

    @active_end_date=99991231,

    @active_start_time=0,

    @active_end_time=235959

    For future reference, those are documented in BOL as part of the sysschedules sytem table, but Silverfox's idea of creating a job with those parameters sure makes it easier to understand them.

    Greg

  • October 7, 2009 at 9:39 am

    #1062885

    Thanks, I checked BOL but at first didn't understand the explanation. I've went into Job alert and looked at properties and this shows the GUI set up

    Cheers

Viewing 6 posts - 1 through 5 (of 5 total)

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