Emailing Return Parameters from DBPROC JOB

[Anon Anon]

I am new to WA. Is there a way to email the return parameters from a DBPROC job to someone? We want to notify our DBA's if the job fails with the return codes and text from the DBPROC. Alternativly is there a way to get the return codes into a text file so we can use a third-party mailer.

Thanks,

Brent Rollings

[System]

Hi All,

Any input here for Brent?

Thanks!
Chris

[Mark_Hanson]

Email notification has been added to WAAE 11.3.5 via the following job attributes:

send_notification
notification_emailaddress
notification_msg

The notification can be sent if the job runs to SUCCESS or FAILURE. It is not possible to include return codes or other output in the message.

Here are a couple of example jobs from the Administration Guide:

Example: Send an Email Notification when a Job Completes
This example specifies that an email notification should be sent to [e-mail] when job email_job_1 completes.
insert_job: email_job_1
machine: localhost
job_type: c
command: as_test -t 2
send_notification:1
notification_emailaddress:[e-mail]
notification_msg:"email_job_1 has completed"

Example: Send an Email Notification when a Job Fails
This example specifies that an email notification should be sent to [e-mail] when job email_job_fails fails.
insert_job: email_job_fails
machine: localhost
job_type: c
command: as_test -t 2 -e 2
send_notification:F
notification_emailaddress:[e-mail]
notification_msg:"email_job_fails has failed"

Additional information can be found in the Reference Guide as well.

Hope this helps.

Mark

[Legacy User]

Mark,



Is setting up email notification a 2-step process?



1. Configure CA Workload Automation AE to send notifications (Admin Guide, pg. 40)

2. Configure job definition with below optional attributes



From: CA Workload Automation (Distributed) Global User Community [mailto:[e-mail]]
Sent: Wednesday, June 05, 2013 12:39 PM
To: [e-mail]
Subject: [CA AutoSys Workload Automation General Discussion] RE: Emailing Return Parameters from DBPROC JOB



Email notification has been added to WAAE 11.3.5 via the following job attributes:

send_notification
notification_emailaddress
notification_msg

The notification can be sent if the job runs to SUCCESS or FAILURE. It is not possible to include return codes or other output in the message.

Here are a couple of example jobs from the Administration Guide:

Example: Send an Email Notification when a Job Completes
This example specifies that an email notification should be sent to [e-mail] when job email_job_1 completes.
insert_job: email_job_1
machine: localhost
job_type: c
command: as_test -t 2
send_notification:1
notification_emailaddress:[e-mail]
notification_msg:"email_job_1 has completed"

Example: Send an Email Notification when a Job Fails
This example specifies that an email notification should be sent to [e-mail] when job email_job_fails fails.
insert_job: email_job_fails
machine: localhost
job_type: c
command: as_test -t 2 -e 2
send_notification:F
notification_emailaddress:[e-mail]
notification_msg:"email_job_fails has failed"

Additional information can be found in the Reference Guide as well.

Hope this helps.

Mark
Posted by:mark_hanson
--
CA Communities Message Boards
101156962
[e-mail]
https://communities.ca.com

[Juned Khan]

Hi Mark,

Hope you're doing well !

I've done installation and configuration of Autosys WAAE. Now I want enable email notification for jobs. Could you please help me with the config file where I can configure SMTP parameters? If you have any relevant link handy, that would also work. 

Thank you in advance.
Juned

[Michael Woods]

Hi Juned,

Here is a link on setting up the configuration to send an email:
https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/intelligent-automation/workload-automation-ae-and-workload-control-center/11-3-6-SP8/administrating/ae-administration/send-email-notifications.html

To send a very basic email, you  con follow these instructions:
https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/intelligent-automation/workload-automation-ae-and-workload-control-center/11-3-6-SP8/installing/ca-workload-automation-ae-deployment-best-practices/implementation-best-practices/configure-email-notifications.html

To get a bit more customized, you can create your own email templates and have more control on when the email is sent out as well, like for a max runtime alarm for example.
to create the template use this link:
https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/intelligent-automation/workload-automation-ae-and-workload-control-center/11-3-6-SP8/reference/ae-job-information-language/jil-job-definitions/notification-template-specify-the-template-for-the-email-notification.html

The other fields that are used in the job definition to control when an email is sent are at:
https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/intelligent-automation/workload-automation-ae-and-workload-control-center/11-3-6-SP8/administrating/ae-administration/send-email-notifications.html#concept.dita_62093e08f5b69c707140b4d1509d3b1788f44165_SpecifytheNotificationAttributes

We do ship a sample template as you'll see in the doc.

Have fun,
Mike