topic Re: Running reports during certain timeframes only? in Application Development and Automation Discussions

Running reports during certain timeframes only?

EMJ — Thu, 31 Jul 2008 19:39:46 GMT

In our environment, custom reports have been created which, when run, potentially have the ability to bring the system to its knees. I would like to set up some type of authorization that allows the running of reports only at a specific times each day so as not to interfere with our heavy demand times. Is this a possibility, and if so, how do I do this? Is this something that would be built into the report itself, or is this an actual authorization? Thank you.

Re: Running reports during certain timeframes only?

Former Member — Thu, 31 Jul 2008 19:50:43 GMT

Hi,

Schedule the reports as background job using SM36 tcode and mention the timings and date and block the user access to these reports.

Rakesh

Re: Running reports during certain timeframes only?

Former Member — Thu, 31 Jul 2008 19:57:14 GMT

You should be able to schedule running these reports as background jobs.

Goto - SM36,

Come up with a job name for the report that you want to schedule ( having some job naming convention helps )

and enter it in the Job name field.

Click on Start condition and choose when the options of how and when you want to run your report.

Pay attention to period job check box and you can pick and choose your time frame for running the reports.

finally ..click on Step button and enter your report name in the ABAP program section and just follow the steps.

Re: Running reports during certain timeframes only?

Former Member — Tue, 05 Aug 2008 14:30:35 GMT

> Is this something that would be built into the report itself, or is this an actual authorization?

The only actual authorization available for this type of thing is to provide the user only with S_BTCH_JOB authority and not any S_BTCH_ADM. This way, only priority C type jobs will be released by them.

You might want to conside a check upfront in the program to ensure that the report only can run in the background.... system field SY-BATCH can be used for that and possibly also not assign object S_BTCH_JOB authority to them for JOBACTION 'RELE' (i.e. they cannot release the job) and then only release the already scheduled jobs at certain times.

If these reports have to run in the foreground as well, then you can use system field SY-UZEIT in the program and a check table to set the times at which it can be executed.

The possibilities of performance tuning your programs and several others also come to mind

Cheers,

Julius

Re: Running reports during certain timeframes only?

EMJ — Tue, 05 Aug 2008 14:41:02 GMT

Thank you to all who responded, I will take each into account when coming up with a solution for this issue.

Re: Running reports during certain timeframes only?

Former Member — Tue, 05 Aug 2008 14:50:34 GMT

Please also update us with the solution which best suited your requirement. This is informative for others as well, and we might have some comments on the solution as well

Cheers,

Julius