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

[Martin_Lauer]

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?

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.

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.

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:

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

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.

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.

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: