Add an action to log messages to a database with a bulk insert
You can add an action to log messages to a SQL database using a bulk insert. You can use a bulk insert to log multiple events in a single connection to the database, rather than establishing and closing a session for each event.
- From the Kiwi Syslog Service Manager, choose File > Setup.
- Add a rule, or locate an existing rule.
- Right-click Actions below the rule, and choose Add Action.
- Replace the default name with a descriptive name.
-
From the Action menu, select Log to Database - New Bulk Insert.
-
Insert the SQL Server connection string and database table name.
- Insert the number of maximum records, maximum milliseconds, and connection inactivity timeout if needed.
- Test the action.
- Click Apply.