04-29-2008 7:45 AM
hi
i have a job which runs for every 20 min
this jobs runs by taking date as input parameter
say the initial run date is 01.01.2007 and 31.03.2007
this job will automatically increments the date by 90 days
when the date reaches system date i want to restcrict this job from further scheduling
i am repeting it is not job cancelation but i dont want the job from further scheduling
points are for sure
04-29-2008 7:59 AM
guys
do any one know about the table which stores the information of background jobs
because i think if we can uncheck the periodic job option
we can solve this problem
do any one know where this information is stored
04-29-2008 9:59 AM
hi,
Goto sm37
Press F9 u can see processor running , find out ur program select it and go to menu program/session and cancel it
come back select ur program and give stop.
try any tables
Tbtcp
Apqd
Tbtcjstep "Background jobstep overview"
Tbtco Job status overview
Regards,
Priya
04-29-2008 10:14 AM
Hi Ram,
You may use the FM 'BP_FIND_JOBS_WITH_PROGRAM' to check if an existing job is running with the same variant
CALL FUNCTION 'BP_FIND_JOBS_WITH_PROGRAM'
EXPORTING
abap_program_name = sy-repid
ABAP_VARIANT_NAME = ' '
EXTERNAL_PROGRAM_NAME = ' '
DIALOG = ' '
status = 'R'
TABLES
joblist = lt_joblist
EXCEPTIONS
no_jobs_found = 1
program_specification_missing = 2
invalid_dialog_type = 3
job_find_canceled = 4
OTHERS = 5
Hope this helps.
Reward if helpful.
Regards,
Sipra