How to Schedule a Report to run every 5 minutes

[crystal28]

How to Schedule a Report to run every 5 minutes from a particular time for 4 times and each of this 4 times the parameter should change its value.
How to do this in CMC

 

[kskid]

Click on the schedule tab and then click on Daily.

From the run drop down, click on every X hour(s), N minutes(s)

set X to 0 and set N to 5

Set the time and date when you want it to start
set the time and date when you want it to end

Click on Update
Click on Schedule. This will take you to the history tab with the job scheduled as recurring. You may have another instance running depending on the start time and date you entered.

-lw

 

[kskid]

Forgot to ask. What kind of parameters are you using and why do they change for each run?

 

[crystal28]

Parameters are strings and it needs to change every 5 minutes for 4 times,that is the trick part..can we do it?

 

[kskid]

Again, exactly what are the parameters and what effect does it have on the report. Is it part of the record selection?

 

[crystal28]

Yes the parameter is part of record selection,it affects teh query that builds the data for the report...its not a selection formula or a group selection formula.its part of the query that builds teh recordset thru the command object,without it the report wont run..

so i need to have a way where the parameter changes as well as teh report is incremented every 5 minutes,uve answered the second part..

 

[GMcNamara]

So, you are running the report four times five minutes apart? Can't you just manually schedule the four instances?

If that's not the case, what affects the change in the parameter value? Give an example of how/why the parameters are changing.

 

[kskid]

As GMcNamara said, you can easily schedule 4 jobs to run 5 minutes apart in Infoview. By doing so, you can specify wthe parameter values you want to use with each instance.

If the parameter is datetime related, then perhaps a formula can be developed to look at currentdatetime and make the appropriate adjustment.

Bottom line, we need to know what is affecting the parameter value change for each run.

-lw