topic Background Scheduling in Application Development and Automation Discussions

Background Scheduling

Former Member — Mon, 12 Jan 2009 10:37:41 GMT

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

Re: Background Scheduling

Former Member — Mon, 12 Jan 2009 10:42:16 GMT

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.

Re: Background Scheduling

Former Member — Mon, 12 Jan 2009 10:43:36 GMT

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

Re: Background Scheduling

Former Member — Mon, 12 Jan 2009 10:49:26 GMT

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

Re: Background Scheduling

Former Member — Mon, 12 Jan 2009 11:01:53 GMT

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

Re: Background Scheduling

Former Member — Mon, 12 Jan 2009 11:29:00 GMT

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.