topic Re: scheduled Back Ground jobs in Application Development and Automation Discussions

scheduled Back Ground jobs

Former Member — Tue, 10 Jul 2012 06:00:48 GMT

Hi experts,

i have scheduled one back ground job. That schedule will run for one min once.

Every one min the same job has to trigger .

But it has to check whether the previous job has run or not. if its not run it has to wait for the previous job to get complete . then the next job has to trigger.

Kindly advice on this.

Regards,

Srinivasan.V

Re: scheduled Back Ground jobs

former_member209818 — Tue, 10 Jul 2012 06:09:55 GMT

Please use the FM ENQUEUE_ESINDX to fulfill the requirement.

Pass program name in SRTFD field, it will check at that time any other user is running or not.

If program is running, then stop execution of the second program

Regards

Harshad

Re: scheduled Back Ground jobs

Former Member — Tue, 10 Jul 2012 06:16:56 GMT

Hi,

Thanks for your kind response.

My program name length is around 40 characters but that field is not allowing to use such big program name and also my job s scheduled by single user. with same user name only the program will trigger.

My requirement is just to check whether the job has runned or not.I have scheduled the job for every one min. if the program takes more than one min time means the next job should wait until the first gets over.

Regards,

Srini.

Re: scheduled Back Ground jobs

Former Member — Tue, 10 Jul 2012 06:32:42 GMT

Hi Srini,

If you are scheduling for a custom program, you can write a logic inside the program to check whether the job related to the specific program in already running.

You can get the job details in TBTCO.

Cheers

~Niranjan

Re: scheduled Back Ground jobs

Former Member — Tue, 10 Jul 2012 06:34:47 GMT

Hi Niranjan ,

How to check the process,

kindly help me to sort out this issue.

Regards,

Srinivasan.

Re: scheduled Back Ground jobs

Former Member — Tue, 10 Jul 2012 06:50:01 GMT

Hi Srini,

Select all the values from TBTCO with the JOBNAME.

If needed, you can restrict the entries from TBTCO with start date as program run date and start time with +/- 1 hour from the run time.

Then check whether there is one entry with TBTCO-STATUS EQ "R". It means job is running and yet to be finished. You can write a statement to delay the program execution by 5 seconds.

TBTCO-STATUS:

'P'      PRELIMINARY
'S'      SCHEDULED
'Y'      READY
'R'      RUNNING.
'F'      FINISHED
'A'      ABORTED

Cheers

~Niranjan

Re: scheduled Back Ground jobs

Former Member — Tue, 10 Jul 2012 06:55:33 GMT

Hi,

You can write something like this...

data: wa2_tbtco TYPE tbtco,

SELECT * from TBTCO INTO CORRESPONDING FIELDS OF wa2_tbtco
WHERE JOBNAME = (Your job name)

                                     AND Status = 'R'.
       ENDSELECT.

       tbtco_lines = sy-dbcnt.
       WRITE : 'TBTCO LINES WITH STATUS R',tbtco_lines.
       IF SY-subrc EQ 0 AND tbtco_lines gt 1.
            WRITE 😕 'Previous job is still active'.
         LEAVE TO SCREEN 0.
       ENDIF.

Re: scheduled Back Ground jobs

Former Member — Tue, 10 Jul 2012 06:58:38 GMT

HI niranjan,

Thanks for your kind replies,

Actually all my back ground schedules are with status 'P' in TBTCP table.

None of the schedules are with 'F' .

and also i ve written select query to check for whether back schedule or runned or not.

But how to make a job delay ?

whether i need to use wait 10 seconds?

but still if the schedule is not yet completed? how to proceed then ?

TBTCO-STATUS:

'P'      PRELIMINARY
'S'      SCHEDULED
'Y'      READY
'R'      RUNNING.
'F'      FINISHED
'A'      ABORTED

Re: scheduled Back Ground jobs

Former Member — Tue, 10 Jul 2012 07:02:00 GMT

Hi,

Its not tbtcp table it is tbtco.

Re: scheduled Back Ground jobs

Former Member — Tue, 10 Jul 2012 07:07:49 GMT

Hi Qwerty,

Thanks for you too for guiding me on this.

Actually how to check whether the exact previous job has runned or not ?

Regards,

Srinivasan.V

Re: scheduled Back Ground jobs

Former Member — Tue, 10 Jul 2012 07:09:53 GMT

Hi,

use WAIT FOR 2 SECONDS in your report to delay the program execution.

Cheers

~Niranjan

Re: scheduled Back Ground jobs

Former Member — Tue, 10 Jul 2012 07:13:10 GMT

Hi,

The only way you can check is ...

You can check the status of the job in tbtco table .

If it is 'F' then it is finished

If it is 'R' then it is active and still running.

Re: scheduled Back Ground jobs

Former Member — Tue, 10 Jul 2012 07:17:30 GMT

Hi,

i understood the concept . actually if the job s still running means i can check and find out, that this job is still processing.I need to run the same job after the completion of the first job.

how to process it again the same job,

If the status = R means i can use exit or leave to screen

but what abt this job? which has started second.

Regards,

Srinivasan.

Re: scheduled Back Ground jobs

Former Member — Tue, 10 Jul 2012 07:22:36 GMT

Hi,

You said you have given periodic intervals.

so after one minute if the first job is still active and running it will not process the second job until the first job is completed.

Re: scheduled Back Ground jobs

Former Member — Tue, 10 Jul 2012 07:26:24 GMT

No no .

As Discussed with basis team . irrespctive of work load the second job will trigger automatically whether the first job has completed or not .

it will immediately trigger the second oen on time.

So only i have to check the table tbtco

hope you understood my requirement.

Regards,

Srinivasan.

Re: scheduled Back Ground jobs

Former Member — Tue, 10 Jul 2012 07:35:32 GMT

Hi srinivasan,

yes irrespective of work load second instance of job gets triggered.

and what my sample code does is....it will not process the second job it will say finished in 0 seconds.

and will give spool saying...Previous job is still active.

Re: scheduled Back Ground jobs

Former Member — Tue, 10 Jul 2012 07:42:56 GMT

yes. your code says that previous job is still active.

then wat abt this job? will it trigger again?

Re: scheduled Back Ground jobs

Former Member — Tue, 10 Jul 2012 07:45:36 GMT

yes it will....

Re: scheduled Back Ground jobs

Former Member — Tue, 10 Jul 2012 08:14:43 GMT

Hi,

how to check which is last job in the table?

regards

Srinivasan

Re: scheduled Back Ground jobs

Former Member — Tue, 10 Jul 2012 08:18:51 GMT

sort it by sdl date and time