Background Jod scheduling

[Former Member]

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

[Former Member]

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...

[Former Member]

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.

[Former Member]

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

[Former Member]

hi

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.

[Former Member]

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