backgound job problem

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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