topic Re: problem in job scheduling. in Application Development and Automation Discussions

problem in job scheduling.

Former Member — Mon, 16 Aug 2010 06:49:18 GMT

Hi friends,

i have created a BAPI to create purchase order by picking excel files from system . Now i have schedulded this program(se38) by job scheduling (SM36) to run every minute , when i check job overview in SM37 it working fine , but the programm is not executing and its not picking files from folder ,IF i run same programm manually its working fine.

What can be problem?

Please help.

Re: problem in job scheduling.

Former Member — Mon, 16 Aug 2010 06:52:40 GMT

Hi Ishita,

Have you placed the excel file in Application server ( AL11 tcode). Is your program designed to upload from from application server using OPEN DATASET.

If you are using GUI_UPLOAD etc, then it works only in foreground & not in background. For background, you need to use OPEN DATASET.

Thanks,

Best regards,

Prashant

Re: problem in job scheduling.

Former Member — Mon, 16 Aug 2010 07:00:46 GMT

Dear Ishita,

In background job if you want to read file data then it should be only from application server...BG job cant read data from system..

So please explain...if not reading from application server (OPEN CLOSE DATASET) then its not possible ...

Re: problem in job scheduling.

Former Member — Mon, 16 Aug 2010 07:23:44 GMT

hi Sachin,

yes my excel file is on my system , may be that is the problem its not reading the file , is there any way to put the file in application server.

Re: problem in job scheduling.

Former Member — Mon, 16 Aug 2010 07:31:24 GMT

Dear Ishita,

BG job will not read data from your system...

So please put your file on application server and write a code to read that file from application server and update the same from there in sap using open dataset and read dataset...

try to put file with tcode CG3Z to application server and then read that file using open datasets...

Edited by: Sachin Bidkar on Aug 16, 2010 9:35 AM

Re: problem in job scheduling.

Former Member — Mon, 16 Aug 2010 07:31:26 GMT

Hi Prashant,

i m using function module 'ALSM_EXCEL_TO_INTERNAL_TABLE ' ,and yes my excel files are on my system not on application server , how can we put these files on application server.

Re: problem in job scheduling.

Former Member — Mon, 16 Aug 2010 07:38:02 GMT

try to put file with tcode CG3Z to application server and then read that file using open datasets...