RecurrencePattern to JobSchedule

[Mitch]

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

[Yana]

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

[Mitch]

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?

[Yana]

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