I had to use composite pk as jobid is not unique (requeue recreates it). I used jobid,starttime,endtime.
Is there a better solution?
On 05/27/2015 06:13 PM, Daniel Letai wrote:
I know this was previously discussed but I just ran into the same issue today - 3 tables do not have a primary key:*_last_ran_table (I use hourly_rollup) *_suspend_table (I use job_db_inx) and jobcomp_table I'm thinking of using jobid, but would like your input. Thanks in advance, --Dani_L.
