stored procedure in JIRA DB

[Athira K P]

Hi,

Is it feasible to write stored procedure in JIRA database? and the result needs to be sent as a mail to jira-administrator group

[Renjith Pillai]

If you would tell what exactly you want to achieve in the stored procedure, may be there could be other options rather than doing this outside of Jira.

[Nic Brough -Adaptavist-]

Yes, you can, but Jira won't be aware of it, so you'll have to do all the triggering and emailing inside it, or add code to Jira to use it.

[Nic Brough -Adaptavist-]

Oh, and before I forget, it is absolutely critical that your procedure does NOT change Jira data in any way. It MUST be read-only.