Catching python errors in Automic UC4 scheduler

Question

I am executing python scripts through Automic UC4 scheduler. The script connects to Snowflake and executes Snowflake SQL query. The automic scheduler is unable to report in case of SQL compilation errors since the code has been placed under try/except block.

try:
    df = sf.create_df(sql, columns=columns)
except ProgrammingError as e:
    logger.info('Programming error: {}'.format(e))
    sys.exit(1)

Since the program exits through exception block, Automic UC4 considers the script execution to be successful.

Could you please advise how I can let the Automic UC4 know that the job has failed?