topic Re: sample code for executing a job every week in Application Development and Automation Discussions

sample code for executing a job every week

Former Member — Tue, 03 Oct 2006 04:27:14 GMT

hi,

can i hav a sample code to execute to proceess, i.e send the data stored in my tables, every week...(n only once a week, depending, wen i schedule it)

regards,

Vishal

Re: sample code for executing a job every week

Former Member — Tue, 03 Oct 2006 04:33:03 GMT

The sequence of calling the FM`s would be as follows :

JOB_OPEN

JOB_SUBMIT

JOB_CLOSE.

The parameters as in the FM JOB_CLOSE would schedule the job every 1week = min

Re: sample code for executing a job every week

anversha_s — Tue, 03 Oct 2006 04:50:39 GMT

hi,

here i am giving the intervel as 15 minitues..

There are two ways for you to handle,

one manually setting up the job through SM36 which is better and convinient,

secondly through program using FM's JOB_OPEN, SUBMIT, JOB_CLOSE.

Find below steps in doing both:

Procedure 1:

1. Goto Trans -> SM36

2. Define a job with the program and variant if any

3. Click on start condition in application tool bar

4. In the pop-up window, click on Date/Time

5. Below you can see a check box "Periodic Job"

6. Next click on Period Values

7. Select "Other Period"

8. Now give '15' for Minutes

9. Save the job

Procedure 2 via Program:

Below is a sample code for the same. Note the ZTEMP2 is the program i am scheduling with 15mins frequency.

DATA: P_JOBCNT LIKE TBTCJOB-JOBCOUNT,

L_RELEASE(1) TYPE c.

CALL FUNCTION 'JOB_OPEN'

EXPORTING

JOBNAME = 'ZTEMP2'

IMPORTING

JOBCOUNT = P_JOBCNT

EXCEPTIONS

CANT_CREATE_JOB = 1

INVALID_JOB_DATA = 2

JOBNAME_MISSING = 3

OTHERS = 4.

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

SUBMIT ZTEMP2 VIA JOB 'ZTEMP2' NUMBER P_JOBCNT

TO SAP-SPOOL WITHOUT SPOOL DYNPRO

WITH DESTINATION = 'HPMISPRT'

WITH IMMEDIATELY = SPACE

WITH KEEP_IN_SPOOL = 'X' AND RETURN.

CALL FUNCTION 'JOB_CLOSE'

EXPORTING

JOBCOUNT = P_JOBCNT

JOBNAME = 'ZTEMP2'

STRTIMMED = 'X'

PRDMINS = 15

IMPORTING

JOB_WAS_RELEASED = L_RELEASE

EXCEPTIONS

CANT_START_IMMEDIATE = 1

INVALID_STARTDATE = 2

JOBNAME_MISSING = 3

JOB_CLOSE_FAILED = 4

JOB_NOSTEPS = 5

JOB_NOTEX = 6

LOCK_FAILED = 7

INVALID_TARGET = 8

OTHERS = 9.

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

Hope the above helps you.

Kind Regards

anver

if helped mark points

Re: sample code for executing a job every week

Former Member — Tue, 03 Oct 2006 05:05:48 GMT

thanx Anversha..

also, tell me, if i want to schedule it once a week, as per ur 2nd solution, do i need to convert week into minutes...??

or ther is parameter for week itself?

regards,

Vishal

Re: sample code for executing a job every week

anversha_s — Tue, 03 Oct 2006 05:15:49 GMT

hi,

no need .

chk the FM,

job close - > option 'PRDWEEKS' is there.

rgds

anver

if hlped mark points