Background Scheduling

[Former Member]

Hi Guys,

I am scheduling my report in the Background.

Actually, my report is used to upload an excel file from the specified file path into an Internal table and i am using the Internal table to modify the Database table.

I am using the FM "TEXT_CONVERT_XLS_TO_SAP" and it works correctly in the Foreground and updates the database table.

But when i schedule the report in background it does not update the Database table.

Kindly help.

Thanks and regards,

Frank

[Former Member]

If your excel file is on the local workstaion(PC), it wont get uploaded when you run the prog in background. Keep the file in the application server and read it from there for uploading into table.

regards,

Jinson.

[Former Member]

Hi,

When you use a background job, and retreiving data from the files, then better use the application server.

Use Open datasets and then transfer the data into your internal table and then update the data base.

regards,

venkatesh

[Former Member]

Hi,

yes exactly as they said when ever we are executing program in the background it is always better to read it from the application server only.

using OPEN DATASET <file name>...

READ... and CLOSE DATASET you can do that then the program will execute in the background............

[Former Member]

U r running the program in back ground ,and uploading the excel file for this case better use application server path .

OPEN DATASET dset FOR access IN mode [position]

[os_addition]

[error_handling].

Regards,

Madhu

[Former Member]

Hi,

When you are running background job and fetching tha data from from the file, always better to use the application server.

use open dataset read and close dataset.

Regards,

Jyothi CH.