SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Quarterly Scheduling

 
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite View previous topic
View next topic
Quarterly Scheduling
Author Message
Gary Jensen



Joined: 22 Mar 2000
Posts: 28

Post Quarterly Scheduling Reply with quote

I am running 3.4.6 and have a request to schedule a job every 1st Wednesday of each quarter. This would seem to be a common request for a scheduling product, considering quarterly planning and reporting, and for financial purposes, including taxes. Does this version support quarterly scheduling? If not, will future versions, and is it already planned for release?

Wed Jun 04, 2003 11:47 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7969

Post Re: Quarterly Scheduling Reply with quote

This version does not support Quarterly scheduling. For now in order to implement a quarterly job you would need to create a script type Monthly job to be run on 1st Wednesday of each month.
In the job script you can put the following:

Dim today_date, date
Dim month_no, number

Today today_date
Month today_date, month_no
ChooseCase month_no, END_CHOOSE
Case 1, 4, 7, 10
// do here what you want
CaseElse
Exit
END_CHOOSE:

: I am running 3.4.6 and have a request to schedule a job every 1st Wednesday
: of each quarter. This would seem to be a common request for a scheduling
: product, considering quarterly planning and reporting, and for financial
: purposes, including taxes. Does this version support quarterly scheduling?
: If not, will future versions, and is it already planned for release?

Wed Jun 04, 2003 12:06 pm View user's profile Send private message
Gary Jensen



Joined: 22 Mar 2000
Posts: 28

Post Re: Quarterly Scheduling Reply with quote

Is this planned for a later release?

: This version does not support Quarterly scheduling. For now in order to
: implement a quarterly job you would need to create a script type Monthly
: job to be run on 1st Wednesday of each month.
: In the job script you can put the following: Dim today_date, date
: Dim month_no, number

: Today today_date
: Month today_date, month_no
: ChooseCase month_no, END_CHOOSE
: Case 1, 4, 7, 10
: // do here what you want
: CaseElse
: Exit
: END_CHOOSE:

Wed Jun 04, 2003 2:23 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7969

Post Re: Quarterly Scheduling Reply with quote

We are adding entirely new thing "Calendars" and "User defined schedules" which can provide the solution to Quarterly and all other types of non-prebuilt schedules.

Using these things you can define, for instance, Quarterly Schedule such as "1st Wednesday of every quarter" as a separate item in the job database. That item can be then selected from the schedule types list in the job properties just as agent name can be selected for a remote job or scrip library method can be used in a job script. The main idea is to provide an option to separate schedules from jobs so that they can be shared and reused and the schedule logic can be separated from the job logic.

Again, because business requirement vary infinitely it is impossible to prebuilt all thinkable and unthinkable schedule types. I believe the new option will provide the most flexibility and continence. On the other if you name new schedule type as "Quarterly, 1st Wednesday" then you can clearly see that name in the job properties and do not confuse it with the Monthly schedule as In the solution proposed earlier.

: Is this planned for a later release?

Wed Jun 04, 2003 3:46 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7969

Post Re: Quarterly Scheduling Reply with quote

Sorry I meant "convinience" not "continence" in the previous message.

: We are adding entirely new thing "Calendars" and "User defined
: schedules" which can provide the solution to Quarterly and all other
: types of non-prebuilt schedules.

: Using these things you can define, for instance, Quarterly Schedule such as
: "1st Wednesday of every quarter" as a separate item in the job
: database. That item can be then selected from the schedule types list in
: the job properties just as agent name can be selected for a remote job or
: scrip library method can be used in a job script. The main idea is to
: provide an option to separate schedules from jobs so that they can be
: shared and reused and the schedule logic can be separated from the job
: logic.

: Again, because business requirement vary infinitely it is impossible to
: prebuilt all thinkable and unthinkable schedule types. I believe the new
: option will provide the most flexibility and continence. On the other if
: you name new schedule type as "Quarterly, 1st Wednesday" then
: you can clearly see that name in the job properties and do not confuse it
: with the Monthly schedule as In the solution proposed earlier.

Wed Jun 04, 2003 3:47 pm View user's profile Send private message
Jason Hoskins



Joined: 12 Mar 2004
Posts: 68

Post Re: Quarterly Scheduling Reply with quote

Is this available in 3.4.20? I do not see a calendar option so I am assumming not. What version will this be available?

Wed Aug 11, 2004 11:25 am View user's profile Send private message
Jason Hoskins



Joined: 12 Mar 2004
Posts: 68

Post Re: Quarterly Scheduling Reply with quote

I also found that 3.4.20 does not have the MONTH function. I do not see a comparable function available, such as, datepart.

Jason

Wed Aug 11, 2004 11:38 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7969

Post Re: Quarterly Scheduling Reply with quote

This will be available in version 4.0

For now use the provided workaround

: Is this available in 3.4.20? I do not see a calendar option so I am assumming
: not. What version will this be available?

Wed Aug 11, 2004 12:44 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7969

Post Re: Quarterly Scheduling Reply with quote

Use DateTimePart function. It can return any part including month, quarter, year, etc...

: I also found that 3.4.20 does not have the MONTH function. I do not see a
: comparable function available, such as, datepart.

: Jason

Wed Aug 11, 2004 12:46 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.