Schedule a job to run Ad hoc query and save to local automati cally

[Roehlen, Peter]

Hi Julian,
 
I'm not sure that is a workflow question, but anyway....
 
It is my understanding that it is not possible to schedule a job and have
the output saved to a local drive.  Local drives exist on what is
technically known as the presentation server (or front-end) and access to it
is only available through the SAPgui.  Therefore a program needs to be
running in foreground on the SAPgui in order for it to transfer data to the
presentation server.  Background jobs run on the application server without
a SAPgui session.
 
You may be able to achieve a similar result by either:
 
1) having your program send the results via mail
2) write the results to the application server file system and ftp it from
there.
 
Regards
 
Peter Roehlen
Team Lead - SAP Technical & Development
Powercor Australia Ltd
0409 950 263
 
 
 
-----Original Message-----
From: Ming Yang [mailto:myang at dmax-ltd.com]
Sent: Wednesday, 30 January 2002 5:55
To: SAP-WUG at MITVMA.MIT.EDU
Subject: Schedule a job to run Ad hoc query and save to local
automatically
 
 
Does anyone have experience scheduling a job to run an Ad hoc query and
automatically save the output report to local drive regularly? Our HR
department currently run an Ad hoc query daily at 8:00am and manually save
it to local drive. They want our Basis team create and schedule a job to run
and save it automatically.
 
Any comments will be much appreciated!
 
Julian Yang
3100 Dryden rd.
Dayton, OH45439
tel: 937-4259746
 
 
**********************************************************************
Powercor Australia Ltd. This email and any file attachments are
confidential and intended solely for the use of the individual or
entity to whom they are addressed. If you have received this email in
error please tell us immediately by return email and delete the
document.
**********************************************************************