Skip to Content

Scheduling Periodic Job has one limitation , We can not schedule the job for a particular time frame .

Lets Say if you want to schedule the job every one minute for one week only .In order to achieve this , we have to schedule the periodic job which will run every one minute and then after one week we need to manually delete the job.

So In order to overcome this limitation i have written simple report which will schedule the periodic job for a given time frame.

This report will schedule two jobs , one to run the report periodically and other job to delete the first job after the given time frame.

Start Date and Start Time( Low)  implies the start time for the first job ,similarly Start Date and Start Time( High) implies the start time for the second job which will delete the first job.You can also specify the Day on which job should be scheduled.


You can also specify the Job Prefix name , first job will be created with the name of the Prefix followed by ‘_JOB’ followed by the timestamp and second job will have ‘_DEL’  and the timestamp.

Period in Mnts is for the first job to specify how often it should be run.


Attached Document has the source code for the report.

To report this post you need to login first.


You must be Logged on to comment or reply to a post.

  1. Former Member


    While schduling the job with SM36, we are giving the dates between that only system run the job, what will the advatnage over that. 

       Is there any option to run a job every 1 hour daily but only between 9:00 AM to 6:00PM with in office timing?



    1. Jayashree Desai Post author

      Hi Zafar,

      I have tried that , but unfortunately that will not work.I guess end date what we provide in sm36 is only for one specific instance of periodic job.

      Yes , you can achieve this option also by this report.

      Provide the below inputs .This will run for one month , if you want to execute it continuously , then it requires some minor changes in the report.




  2. Jelena Perfiljeva

    Hm, an interesting idea. ๐Ÿ™‚ There are some limitations (e.g. only one step can be added to the job), but it could probably be expanded. Perhaps this could even be a start of some community project to put Redwood out of business. ๐Ÿ™‚

    1. Jayashree Desai Post author

      Hi Stephane,

      Standard Report would do the same job as SM36 , meaning it will just create periodic job and it will be run continuously Like if you schedule job every 3 minutes , it will be run continuously unless you delete it manually .

      But the Report which is suggested in the blog will create a periodic job within particular frame.  Here you can schedule job every 3 minutes from Monday 9.00am to Tuesday 6.00pm.

      1. Former Member

        Hi Jayashree,

        As far as I can tell, report BTCAUX10 does exactly what you want (similar to your program) and not what you’ve described in your comment.

        However, it solves it little differently than you solution:

        The report schedules every time a non-periodic job. This job consists of two steps: the first one is responsible for scheduling of the next job (as long as it may start in the requested timeframe), while the second step is the “real” report to be executed.

  3. SolMan SolMan Project

    We’ve a requirement that there are two jobs A and B which runs daily and every 15 mins respectively. So now, we need to hold both the jobs for about 12 hours end of this month, that is, from 10PM 31st March 2017 to 10AM 1st April 2017. So, how do we achieve this requirement? Could anyone please help me out or give some idea to try it out?

    Thanks in advance.


Leave a Reply