John Swinney has been urged to sack his embattled Health Secretary for misleading parliament and other severe failings in his job.