‎2008 Sep 19 6:24 AM
Hi all,
i want a list of programs which are scheduled daily and monthly....i tried sm37 but didn't find any option
is there any table available for this ??
thnx.
‎2008 Sep 19 6:29 AM
check in this table
TBTCI
TBTCJSTEP
TBTCO
TBTCP
TBTCR
TBTCS
Regards
Anbu B
Edited by: Anbu B on Sep 19, 2008 7:30 AM
‎2008 Sep 19 6:30 AM
Hi sandeep,
Check program RSPC_DISPLAY_JOBS
Hope this helps
Thanks
Lakshman
‎2008 Sep 19 6:31 AM
‎2008 Sep 19 6:33 AM
Hi Sandeep,
Go to transaction SM36. Click on job selection and give the date in the job start condition and select the checkbox Scheduled and execute. You will get the job overview.
Regards,
Chandra Sekhar
Edited by: Chandrasekhar Gandla on Sep 19, 2008 11:04 AM
‎2008 Sep 19 6:33 AM
hi,
use these tables.
TBTCO Job Status Overview Table
TBTCP Background Job Step Overview
TBTCR Batch scheduler execution time
TBTCS Background Processing: Time Schedule Table
‎2008 Sep 19 6:52 AM
actually i want to know which programs are scheduled hourly , daily and monthly ....
my requirement of input and output parameter is as follows...
input = hourly, monthly or daily
output = program name and user who scheduled it
is there any program or table avaialable for this??
‎2008 Sep 19 7:00 AM
Have you checked table: TBTCS???
A simple select statement as below should give you the details of the jobname the scheduler:
SELECT jobname sdluname INTO i_per_jobs
FROM tbtcs
WHERE periodic = 'X'.Try to explore with the details provided...
~Eswar