Is there any possibility to retrieve list of applications and job definitions which are using Email notifications ?

[Mukul Rafiz]

Hello Community members,

Is there any way to list the applications and job definitions which are using Email notifications, either through SQL query or through CLI and also filter it to the granular level, which exit code is being used either for success or failure ?

Appreciate any help here.

Thanks.

[Ravi Kiran Kunduri]

You can run jobmap cli command and that will list all job information. From that you can search for the alert and get to know what jobs are using it. 

Please refer the usage from https://techdocs.broadcom.com/us/en/ca-enterprise-software/intelligent-automation/ca-workload-automation-de/12-3/utilities-and-soap-web-services-functions/using-the-cli/applications-and-jobs-cli-commands/jobmap-command-create-a-job-activity-report.html

Example -

-> jobmap events("SCHEDMASTER.EXIT_CODE")

Event Name:SCHEDMASTER.EXIT_CODE

-----------------------------------------------------------

Application Name:EXIT_CODE

===========================================================

Agent Name:ESP_G36R0T3_7500

Execution Time(min):0.0

Anticipated End Time:11:56:43 Mon 15 Sep 2025

***********************************************************

Job Name:UNIX0

Job Type:UNIX

Arguments To Pass:a

Run Schedule:DAILY

Auto-Resubmit failed job:RetryCount(0) RetryInterval(0)

Exit Code:ExitCode1(Range(400-500) State(S)) ExitCode2(Range(600-700) State(F))

Life Time(min):0.0

Anticipated End Time:11:56:43 Mon 15 Sep 2025

Agent Name:a

Script To Run:a

Execution Time(min):0.0

Anticipated Start Time:11:56:43 Mon 15 Sep 2025

***********************************************************

Job Name:WINDOWS0

Job Type:NT

Run Schedule:DAILY

Auto-Resubmit failed job:RetryCount(0) RetryInterval(0)

Exit Code:ExitCode1(Range(0-99) State(S)) ExitCode2(Range(100-150) State(F))

Life Time(min):0.0

Anticipated End Time:11:56:43 Mon 15 Sep 2025

Agent Name:a

Execution Time(min):0.0

Anticipated Start Time:11:56:43 Mon 15 Sep 2025

***********************************************************

Hope it helps!

[Ravi Kiran Kunduri]

-> jobmap events("SCHEDMASTER.EXIT_CODE")

Event Name:SCHEDMASTER.EXIT_CODE

-----------------------------------------------------------

Application Name:EXIT_CODE

===========================================================

Agent Name:ESP_G36R0T3_7500

Execution Time(min):0.0

Anticipated End Time:12:00:30 Mon 15 Sep 2025

***********************************************************

Job Name:UNIX0

Job Type:UNIX

Arguments To Pass:a

Run Schedule:DAILY

Auto-Resubmit failed job:RetryCount(0) RetryInterval(0)

Exit Code:ExitCode1(Range(400-500) State(S)) ExitCode2(Range(600-700) State(F))

Life Time(min):0.0

Anticipated End Time:12:00:30 Mon 15 Sep 2025

Agent Name:a

Script To Run:a

Notification Email:Notify1(Monitorstates(FAILED) RC(99) Mailaddresslist([e-mail]) EmailTextUseFlag(APPEND_TO_GLOBAL) Attachspoolfile(N))

Execution Time(min):0.0

Anticipated Start Time:12:00:30 Mon 15 Sep 2025

***********************************************************

Job Name:WINDOWS0

Job Type:NT

Run Schedule:DAILY

Auto-Resubmit failed job:RetryCount(0) RetryInterval(0)

Exit Code:ExitCode1(Range(0-99) State(S)) ExitCode2(Range(100-150) State(F))

Life Time(min):0.0

Anticipated End Time:12:00:30 Mon 15 Sep 2025

Agent Name:a

Notification Email:Notify1(Monitorstates(COMPLETE) RC(12) Mailaddresslist([e-mail]) EmailTextUseFlag(APPEND_TO_GLOBAL) Attachspoolfile(N))

Execution Time(min):0.0

Anticipated Start Time:12:00:30 Mon 15 Sep 2025