Splunk alert base on return code

[LolabhattuA]

My file contains a line at the last where it mentions the return code. The format look like below mentioned. If the job fails, It returns 32 and if the job is successful it returns 0.

Main -> ** Execution completed with returnCode: 0,

Can some one help me in building a splunk query to alert me if the code is 32 or 0.

[ITWhisperer]

Start by building a report with the data you want in the alert

Have you already ingested the file as a series of events?

Which fields have you already extracted from the events?

Is there more than one job in the file you are monitoring?

[LolabhattuA]

Yes, The file is already ingested into the Splunk,

Only one esp job is being listed in the file.

[ITWhisperer]

Can you share some of the events using a code block </>

[SinghK]

|inputlookup (your lookup)| search (returncode= 32 OR returncode=0)