Thanks for those who gave me feedback and suggestions. I believe I found the correct syntax for the TRIG_COND that I was looking for ...
DB_TRIG T3K5555$.FM#TEST
TAG 'Test Trigger'
AGENT %PrimaryAgent
TRIG_TYPE UPDATE
TABLE_NAME tblSystemStatus
TRIG_COND '(SELECT iStatusValue FROM tblSystemStatus WHERE +
cStatusId=''ARROUpload'')=1'
Run Daily
ENDJOB
Here's what was in the db.log file ...
04/16/2019 14:49:45.818-0400 4 DatabasePlugin.database Internal Thread.DbTrigHandler.runSql[:339] - SQL: CREATE TRIGGER CYB_1555440585807
ON tblSystemStatus
FOR UPDATE AS
IF ((SELECT iStatusValue FROM tblSystemStatus WHERE cStatusId='ARROUpload')=1)
INSERT INTO dbo.CYB_TRIG_LOG (TRIG_NAME, WOB_ID, MGR_ID, ALERT_NAME, PROCESS_FLAG, CREATED)
VALUES ('CYB_1555440585807','T3K5555$.FM#TEST/T3K1SSIS.25/MAIN','JavaAgent#tcpip@MCB_MANAGER','','N',GetDate());
04/16/2019 14:51:33.052-0400 4 main.Thread-5.DbTrigHandler.runSql[:339] - SQL: DROP TRIGGER CYB_1555440585807