‎2006 Oct 03 5:27 AM
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
‎2006 Oct 03 5:33 AM
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
‎2006 Oct 03 5:33 AM
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
‎2006 Oct 03 5:50 AM
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
‎2006 Oct 03 6:05 AM
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
‎2006 Oct 03 6:15 AM
hi,
no need .
chk the FM,
job close - > option 'PRDWEEKS' is there.
rgds
anver
if hlped mark points