|Home • Trainings • Quiz • Tips • Tutorials • Functional • Cert Q's • Interview Q's • Jobs • Testimonials • Advertise • Contact Us|
Creating Alerts on the basis of status of the Background Jobs with the help of ABAP Query
By Gaurav Chawla, Infosys
a times there is requirement such as user wants to know whether a background job
was executed successfully or not. User wants to have updates or alerts or mails
in case a scheduled job failed or aborted or executed successfully.
that purpose we can either write the entire code in ABAP or we can take help of
ABAP Query. Writing a Code can be a cumbersome task as well as time consuming.
With the help of ABAP Query our coding effort is saved and similar functionality
can be achieved in very less time compared to writing an ABAP code.
to Generate Alerts
an ABAP Query
Help of SQ03 transaction create a user group
Button “Assign users and InfoSets”, we can authorize users who can execute
the ABAP Query.
SQ02 transaction, Create InfoSet.
join two tables there is a button “Insert table” on next screen.
on “InfoSet Maintenance” button in application toolbar.
Pop Up is displayed. Click on “Create Empty Field Groups” radio button and
a field group and insert fields into the field group by right click on fields
and click on “Add field to field group”.
can add other fields as well based upon what kind of output user wants.
example in this case we want to find out the jobs that are started by a
particular person and the status of the job. So we added fields “Initiator”
and “State of background jobs” in field groups.
Role/User Group Assignment, assign the User Group “ZABORT_UGRP” created
above to InfoSet and press Save.
to SQ01 transaction to create an ABAP Query.
the help of ABAP Query we can avoid coding and get the results based on the data
entered on the selection screen.
can select the output format. By click on “Basic List” button in application
toolbar you can select the fields to be displayed in output and on Selection
Please send us your feedback/suggestions at webmaster@SAPTechnical.COM
©2006-2007 SAPTechnical.COM. All rights reserved.
product names are trademarks of their respective companies. SAPTechnical.COM
is in no way affiliated with SAP AG.
Graphic Design by Round the Bend Wizards