I setup an event to update the database via a data modification stored procedure, but event studio will not allow me to set the value of the arguments. It actually reads all arguments just fine, but the Method dropdowns and Value text boxes are disabled. When I preview the event, I get this statement:
The stored procedure for this database update does not accept arguments. It would run once using the default task execution rules. However, when this agent runs, it will perform this task only for the events that meet the specified execution rules: 'New events; Ongoing events'.
Attached is what I see in event studio.
Note that even framework manager sees the arguments as 'in'.
This is for Cognos 8.4.
Anyone know what I'm missing?
Thanks!
Ross
Found the solution: http://www.cognoise.com/community/index.php/topic,982.0.html
I did not have a parameter defined in the value of the argument within framework manager. Would be nice if event studio's help would list that as a requirement too...