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
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.
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.
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.
It looks like you're new here. Sign in or register to get started.
