Launch custom event on a table from sql

Hi all,

I have a custom event on the table PersonWantsOrg, I want to launch this event in bulk for 800 rows,

I could I do it from an sql script? There is a way to do this inside One Identity?

I have a custom process on DialogDatabse that run an HandleObjectComponent - FireGenEvent step taking table event and where string but it doesn't work due (I think) to the length of the where condition for the 800 rows...

Thanks

Mik

Parents Reply Children
  • Thanks for the answer Markus.

    Usually I have a process on Dialog database that call and HandleObjectComponent - FireGetEvent not an sql script.

    with this parameters:

    EventName

    ObjectType

    WhereClause.

    My where clause is very very long e.s. CCC_MyCustomColumnRef in (.......) with a lot of ref in the parenthesis

    If I call the event with the long where clause nothing happen, if I call the event with just a bunh of ref it works.