|
SAP Community Network Forums
»
Industries
»
IS - Media
Thread: Scheduling Query
 |
This question is not answered.
|
|
Replies:
2
-
Pages:
1
-
Last Post:
Oct 30, 2009 12:18 PM
Last Post By: Nabil Zebbar
|
|
|
|
|
|
|
Scheduling Query
Posted:
Sep 1, 2009 12:09 PM
|
|
|
|
Hoi,
Recently i have create a query using transaction SQ01 on R/3 System, everything is going well.
My question is:
There a way to schedule my query, so it can be performed monthly en saving the output to an appropriate destination.
I will appreciate your help.
Kind Regards.
Nabil Zebbar
|
|
|
|
|
|
Re: Scheduling Query
Posted:
Sep 11, 2009 6:16 PM
in response to: Nabil Zebbar
|
|
|
|
When you execute the query, click System > Status to get the program name. It will be something like AQZZZ....
You should be able to schedule a job in SM36 for that program name. You will also need a variant saved for the query and will have to specify that variant.
Your output will be in a spool, or you could create a distribution list using S015. (Myself I'm not sure about saving the output to another destination.)
|
|
|
|
|
|
Re: Scheduling Query
Posted:
Oct 30, 2009 12:18 PM
in response to: Bob W Williams
|
|
|
|
Hoi Bob,
Thanks voor your answer.
Just one question please!
When i execute en perform my query in an Job selection, i did not see any spool generated with the output, thus the spool wouldn't be created.
Any Idea?
Thanks again
|
|
|
|
|
