I'm not saying it's not a real job, I'm saying that in the context of stimulus created jobs they're generally:
1. Short term, and after this the employees have to go on to find work in private sectors of the economy anyway.
2. In sectors of the economy where we've 'picked winners' (which historically the government isn't so great at). Most recent example is that the insulation scheme: the govt decided that installing insulation was the most effective way to tackle global warming, over say investing more in renewables research, constructing nuclear plants, or the like. Here, also, it's easy to see that the insulation wasn't creating anywhere near as much real worth for home owners as the government was paying for the insulation itself, so that's a deadweight loss.