[Solved] [ES] EventStudio database modification procedure issue

[mikewalker]

Anybody noticed that with the database update task within EventStudio, the options to specify how stored procedure parameter values are set/handled appear disabled?

The stored proc parameters can be seen (they are displayed in the task details page), but the properties to define their values & behaviour are 'greyed out'.Ã,  ???

Any help or ideas would be appreciated..

Regards
Mike

[mikewalker]

Cognos Support helped out with this one...

After importing the stored procedure into the FM model, and marking it as a 'data modification' procedure, you need to set values for the stored proc's parameters - the values can be either static or dynamic, and in the latter case it makes sense to put a "prompt" as the value.

eg for the @param1 parameter in my stored procedure I have set its value (in FM) to ?param1_prompt?

This will enable the parameters to be configured within Event Studio.

[dwood09]

Hi All,

Have you actually had success running an update stored proc through Event Studio?

Love to hear that you have ... mine does not seem to work!

cheers,
DW

[MFGF]

It's only a simple SP, but yes it works fine.

What problems are you getting?

MF.