topic Background Jod scheduling in Application Development and Automation Discussions

Background Jod scheduling

Former Member — Fri, 22 Sep 2006 12:31:07 GMT

Hi friends,

I am new to background job scheduling. I've a requirement where I need to run a background job for a program and the file should be saved as:

Drive: C

Folder: Temp.

Name: PgmName_ date .txt or csv.

Then, through the same program this file should be downloaded to excel format.

Please guide me in achieving this.

Thanks,

Sharmila

Re: Background Jod scheduling

Former Member — Fri, 22 Sep 2006 12:34:43 GMT

hi,

1. create a variant for ur program.

2. now in SE38 PROGRAM -> EXECUTE -> BACKGROUND

3. system will ask the variant. give what u have created

4. u can now go to <b>SM37</b> and see the details of job. like the output, log messages, time taken in sec. etc

hope it helps...

reward if useful...

Re: Background Jod scheduling

Former Member — Fri, 22 Sep 2006 12:37:41 GMT

Hi,

If you are trying to download the file on the presentation server then it is not possible through background job.

If you are placing that file in Application server then you need to handle the code in Abap program and download the file.

For creating the background job goto SM36 and create a job and your program as job step .

Hope this helps.

Re: Background Jod scheduling

Former Member — Fri, 22 Sep 2006 12:40:53 GMT

http://help.sap.com/saphelp_47x200/helpdata/en/ef/2c513897110872e10000009b38f889/frameset.htm

Re: Background Jod scheduling

Former Member — Fri, 22 Sep 2006 12:41:57 GMT

sm36->give a job name ->job class (according to ur priority)-> status as schduled

Click on start condition here u decide wht time u want the job to be scheduled.

save your settings.

next click on job steps . Specify the name of the report and save it.

Go to the job and save it there.

Go to job selection and click on execute.

Reward useful answers.

Regards,

Shrita.

Re: Background Jod scheduling

Former Member — Fri, 22 Sep 2006 12:42:48 GMT

Hi,

use sm36 transaction to define job

and sm37 to execute the job.

you can schedule job in program by

calling FM 'JOB_OPEN','JOB_SUBMIT','JOB_CLOSE'.

use FM 'GUI_UPLOAD' to download file in .txt,.csv

use FM EXCEL_OLE_STANDARD

EXCEL_OLE_STANDARD_DAT

MS_EXCEL_OLE_STANDARD_DAT

Regards

amole