IBM Support

How to change running frequency of the Universal connector for Snowflake

Question & Answer


Question

How can I change the schedule frequency of the Universal Connector for Snowflake to run every 30 minutes?

Cause

A user wants to change the schedule parameter that controls the running frequency of the Universal Connector for Snowflake audit.

Answer

From GUI -> Configure Universal Connector page.

The Input Configuration has a line like :

schedule =>  "* * * * *" 

The default value "* * * * *"  means that executing every minute.

Generally, the schedule can be set like  i.e. "a b c d e"
a - minute
b - hour
c - day
d - month
e - day of the week

An asterisk (*) stands for all values

A comma (,) specifies separate individual values

A dash (-) indicates a range of values

A forward-slash (/) is used to divide a value into steps

For example, if you want to run audit logs every 30 minutes, can set up:

schedule =>  "0,30 * * * *"  
Then restart Universal Connector from the GUI by disable and re-enabling again.

[{"Type":"MASTER","Line of Business":{"code":"LOB24","label":"Security Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"ARM Category":[{"code":"a8m3p0000006xcfAAA","label":"UNIVERSAL CONNECTOR"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.3.0;11.4.0;11.5.0"}]

Product Synonym

Guardium;Universal Connector;Snowflake

Document Information

Modified date:
20 July 2023

UID

ibm17013523