| Author | 
		Message | 
	
	
		
			Gary Jensen 
			 
			
  
			
			
				Joined: 22 Mar 2000 Posts: 28
  | 
			 
			  
		 | 
		
			
				  Quarterly Scheduling | 
				     | 
			 
			
				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 | 
		          | 
	
	
		  | 
	
	
		
			SysOp 
			Site Admin 
			
  
			
			
				Joined: 26 Nov 2006 Posts: 7991
  | 
			 
			  
		 | 
		
			
				  Re: Quarterly Scheduling | 
				     | 
			 
			
				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 | 
		          | 
	
	
		  | 
	
	
		
			Gary Jensen 
			 
			
  
			
			
				Joined: 22 Mar 2000 Posts: 28
  | 
			 
			  
		 | 
		
			
				  Re: Quarterly Scheduling | 
				     | 
			 
			
				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 | 
		          | 
	
	
		  | 
	
	
		
			SysOp 
			Site Admin 
			
  
			
			
				Joined: 26 Nov 2006 Posts: 7991
  | 
			 
			  
		 | 
		
			
				  Re: Quarterly Scheduling | 
				     | 
			 
			
				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 | 
		          | 
	
	
		  | 
	
	
		
			SysOp 
			Site Admin 
			
  
			
			
				Joined: 26 Nov 2006 Posts: 7991
  | 
			 
			  
		 | 
		
			
				  Re: Quarterly Scheduling | 
				     | 
			 
			
				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 | 
		          | 
	
	
		  | 
	
	
		
			Jason Hoskins 
			 
			
  
			
			
				Joined: 12 Mar 2004 Posts: 68
  | 
			 
			  
		 | 
		
			
				  Re: Quarterly Scheduling | 
				     | 
			 
			
				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 | 
		          | 
	
	
		  | 
	
	
		
			Jason Hoskins 
			 
			
  
			
			
				Joined: 12 Mar 2004 Posts: 68
  | 
			 
			  
		 | 
		
			
				  Re: Quarterly Scheduling | 
				     | 
			 
			
				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 | 
		          | 
	
	
		  | 
	
	
		
			SysOp 
			Site Admin 
			
  
			
			
				Joined: 26 Nov 2006 Posts: 7991
  | 
			 
			  
		 | 
		
			
				  Re: Quarterly Scheduling | 
				     | 
			 
			
				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 | 
		          | 
	
	
		  | 
	
	
		
			SysOp 
			Site Admin 
			
  
			
			
				Joined: 26 Nov 2006 Posts: 7991
  | 
			 
			  
		 | 
		
			
				  Re: Quarterly Scheduling | 
				     | 
			 
			
				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 | 
		          | 
	
	
		  | 
	
	
		 |