Skip to Content
Author's profile photo Martin Lauer

How to send an email with a custom job report from Job Management Work Center

Do you need to know by the time you enter the office if the jobs that were scheduled during the night ended without errors?

Do you want to receive customized job reports on your mobile device?

Would you like to be able to receive the result of a Job Management POWL query, for example the list of jobs in a 24h time window as shown below, by email?

00 jsm_wc_smse_query.png

Prerequisites:

1. You have SAP Solution Manager Support Package 10 or higher installed

2. You have to create the required POWL queries in the Job Management Work Center that either

a) Collects the job data from the SAP system directly or

b) Collects the job data from an external job scheduler like SAP CPS by Redwood

The queries have to use dynamic time windows in order to get for example the job runs during the past 24 hours.

Configuration:

Once the queries are available you navigate in the Job Management Work Center to the Administration view and start the configuration of the POWL Query Result notification. As the name implies this works for al kinds of POWL queries and not only for the queries defined in the Job Management Work Center.

10 jsm_wc_admin - config.png

In the configuration application you just select Add, then select the POWL query you want to receive (make sure that you have selected the correct type of query) and enter your business partner number.

11 jsm_wc_admin_new_query_result.png

After pressing OK you should see your configuration in the list of available configuration. Select your configuration and the assigned business partners will be displayed:

12  jsm_wc_admin_new_query_result_2.png

Of course it is possible to assign more than one business partner to a configuration as you can see from this example:

13 jsm_wc_admin_new_query_many_recipients.png

Automation

Now that the configuration has been done return to the  Administration view in the Job Management Work Center and select Schedule Job in section POWL Query Result Configuration.

20 jsm_wc_admin -schedule.png

The job scheduling of Job Scheduling Management will be started already prefilled with the report to be schedule. Just enter your preferred start time and recurrence and you’re done.

21 jsm_wc_schedule_email_job.png

Result:

What’s next? Just wait for the job to run and you will receive an email containing the results of your POWL query, see the example below:

30 POWL_email.png

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Martin Lauer
      Martin Lauer
      Blog Post Author

      Regarding customizing of the email: SAP provides BAdI BADI_BUILD_POWL_EMAIL for this purpose. See default implementation CL_AGS_EJR_BUILD_POWL_EMAIL for more information

      Author's profile photo Former Member
      Former Member

      Hi Martin

      is there anyway one can do the following :

      1- automate the BPA process

      2. Inform the business via email once the auto process is completed

      example :

      business wants the business process owner to be informed via email that the BPA for IDOcs is ready

      Author's profile photo Martin Lauer
      Martin Lauer
      Blog Post Author

      Hi,

      for 1. SAP Automation I recommend to use SAP CPS by Redwood and Job Chains:

      for 2. Once you have automate your process using job chains you can add an notification job at the end of the process.

      Kind regards,

      Martin

      BTW: you might also want to evaluate Redwood Insight: http://www.redwood.com/resources/library/download/510-redwood-insight-solution-sheet