RecurrencePattern to JobSchedule

4 posts, 0 answers
  1. Mitch
    Mitch avatar
    2 posts
    Member since:
    Oct 2013

    Posted 12 Dec 2013 Link to this post

    Hello,

    I'm using Telerik ScheduleView to schedule SSIS Jobs.
    I'm getting headaches, trying to convert the property values of RecurrencePattern to the properties of JobSchedule.
    Has anybody done this before? I could really use some help.

    Here are the properties of RecurrencePattern.
    http://www.telerik.com/help/wpf/allmembers_t_telerik_windows_controls_scheduleview_recurrencepattern.html
    And here are the properties of JobSchedule
    http://technet.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.agent.jobschedule.aspx

    For example, I'm able to translate RecurrenceFrequency to JobSchedule's FrequencyTypes. But that's about as far as I got.
    I'm hoping somebody has done this before. Otherwise I'm hoping to get some help, that'd be awesome.

    Thanks in advance,
    Mitch
  2. Yana
    Admin
    Yana avatar
    4554 posts

    Posted 16 Dec 2013 Link to this post

    Hi Mitch,

    We do not have such an example and I'm afraid we're not quite familiar with JobSchedule class, however, you can check this help topic for more detailed information on the RecurrencePattern class properties.

    Also if you have any specific questions on the RecurrencePattern, we will be glad to help.

    Regards,
    Yana
    Telerik
    TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for WPF.
    Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
    Sign up for Free application insights >>
  3. UI for WPF is Visual Studio 2017 Ready
  4. Mitch
    Mitch avatar
    2 posts
    Member since:
    Oct 2013

    Posted 09 Jan 2014 Link to this post

    Thanks for the reply. That link you gave me is very helpful.
    I'm making progress. Daily and Weekly schedules are working. I just need to fix the Monthly schedules.

    There are 2 types of Monthly schedules. I would call them non-relative and relative.
    1. Every "n-th" Day of the Month    and the Interval Between Each Recurrence is "m" Months
    2. Every "n-th" Week Day               and the Interval Between Each Recurrence is "m" Months

    How can I see which one is selected? Based on a RecurrencePattern object.
    I bet it's not safe to check if... for example.. DayOrdinal == 0
    I tried to use the EnumToBoolConverter. But it requires a RecurrenceType which is not a property of RecurrencePattern.

    Any suggestions?

  5. Yana
    Admin
    Yana avatar
    4554 posts

    Posted 14 Jan 2014 Link to this post

    Hi Mitch,

    When the first option is selected, DaysOfMonth and Interval properties of the RecurrencePattern are set while when the second option is chosen, DaysOfWeekMask, DayOrdinal and Interval properties are set. So you can first check the Frequency and for Monthly Frequency, according to these properties you can define which recurrence exactly is selected.

    I hope this helps.

    Regards,
    Yana
    Telerik
    TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for WPF.
    Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
    Sign up for Free application insights >>
Back to Top