Hi, You can add "Global" parameters in the "kettle.properties" file (in the .kettle directory under the diserver sub directory) such as the below where you can log the status of the Jobs/Transforms/Etc either to a file or a form (xxx_LOG_TABLE) within AR System that you could utilise in monitoring to check the status of your AI Jobs:
Example Parameters: KETTLE_TRANS_PERFORMANCE_LOG_TABLE=UDM\:StepPerformanceLog KETTLE_TRANS_PERFORMANCE_LOG_SCHEMA= KETTLE_CHANNEL_LOG_DB=MPS-ARSystem KETTLE_STEP_LOG_SCHEMA= KETTLE_JOB_LOG_DB=MPS-ARSystem KETTLE_LOG_SIZE_LIMIT=0 KETTLE_TRANS_LOG_TABLE=UDM\:TransformationLog KETTLE_JOBENTRY_LOG_SCHEMA= KETTLE_STEP_PERFORMANCE_SNAPSHOT_LIMIT=0 KETTLE_TRANS_LOG_DB=MPS-ARSystem KETTLE_JOBENTRY_LOG_TABLE=UDM\:JobEntryLog KETTLE_STEP_LOG_DB=MPS-ARSystem KETTLE_STEP_LOG_TABLE=UDM\:StepLog KETTLE_PLUGIN_CLASSES= KETTLE_TRANS_ROWSET_SIZE=0 KETTLE_TRANS_LOG_SCHEMA= KETTLE_JOB_LOG_SCHEMA= KETTLE_TRANS_PERFORMANCE_LOG_DB=MPS-ARSystem KETTLE_MAX_LOG_TIMEOUT_IN_MINUTES=0 KETTLE_EMPTY_STRING_DIFFERS_FROM_NULL=N KETTLE_CHANNEL_LOG_SCHEMA= KETTLE_JOB_LOG_TABLE=UDM\:JobLog KETTLE_JOBENTRY_LOG_DB=MPS-ARSystem KETTLE_SHARED_OBJECTS= KETTLE_MAX_LOG_SIZE_IN_LINES=1000 KETTLE_CHANNEL_LOG_TABLE=UDM\:LoggingChannelLog Alternately, you can turn on individual Job logging via the Spoon Client. _____ Kind Regards, Carl Wilson From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Campbell, Gavin Sent: 13 January 2016 15:31 To: [email protected] Subject: Automated Atrium Integrator Job Monitoring in 8.1.2 environment ** Hi All, Has anyone implemented any type of automation of job monitoring to alert your team when an AI job fails? Outside of checking the AI console on a daily basis we are not finding it easy to monitor our AI jobs to verify they are running as scheduled. Thanks for sharing any input you may have. Best Regards, Gavin _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
