Post reply

SQL Jobs

  • September 8, 2009 at 11:48 pm

    #137992

    Hi,

    I need the procedure that calculates the freq_interval in sysschedules.

    For Example,

    If we select sunday and monday freq_interval store as 3(sunday+monday) since sunday=1, monday =2,tuesday=3..............

    Can any one help me out by giving the procedure that updates freq_interval.

    Thanks,

    Anitha

  • September 9, 2009 at 12:38 am

    #1050914

    The question isn't clear. What is it you want to do?

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

  • September 9, 2009 at 4:08 am

    #1050940

    anithagovindarajalu (9/8/2009)

    Hi,

    I need the procedure that calculates the freq_interval in sysschedules.

    For Example,

    If we select sunday and monday freq_interval store as 3(sunday+monday) since sunday=1, monday =2,tuesday=3..............

    Can any one help me out by giving the procedure that updates freq_interval.

    Thanks,

    Anitha

    I dont understand that either, can you give more details

    --------------------------------------------------------------------------------------
    [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]

  • September 9, 2009 at 4:40 am

    #1050961

    if u have update permissions

    then by this query u can update freq_interval

    update sysjobschedules set freq_interval=3 where schedule_id=?

  • September 9, 2009 at 4:42 am

    #1050963

    I'm not sure what your question is either, but I suspect you may get what you are after by looking at the SQL in these stored procedures in msdb sp_get_schedule_description, sp_help_jobschedule

    i.e. in the context of msdb, run:-

    exec sp_helptext sp_help_jobschedule

    exec sp_helptext sp_get_schedule_description

  • September 9, 2009 at 5:28 am

    #1050991

    This all seems like a very bad plan to me.

    Perhaps if you say what it is you want to achieve by doing this update, we can point you to a supported way of doing it...?

    Maybe sp_update_schedule is what you are looking for? @freq_interval is a named parameter for that (documented and supported) procedure.

    Paul

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

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

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