Mailing RES Wisdom Job Results

Our colleague Rob de Korte proved, once again, that with a little creativity, you can do anything with RES Wisdom (I’m not saying you should ;-).

What he achieved with this example is to send an e-mail containing the results from a recurring job.

Here’s how he did it:

Go to Job Scheduling and right-click the recurring query. Select ‘Export job results…’. Note: do this from the Job Scheduling node to get the latest results every day. If you do it from the Job Results node, you will only get the results of one job over and over again.

In the Export Job Results dialog box, select an appropriate path to store the xml file and click the button Copy Command Line:

Close the Export Job Results window.

Create a new task Execute Command, and paste the command line into the Command line field:

NB: If the path contains spaces, remember to put quotes around the executable path name.

Then create a task Send Mail that sends a mail to the appropriate recipient(s). As attachment you can include the xml file you just created:

You can add some maintenance tasks to delete the xml file from the day before.

Note: the agent that executes this job needs to have the RES Wisdom Management Console installed.

Of course, if you want to have this information sent regularly, you can create a recurring schedule for this task as well.

Cool! Thanks Rob!