How can I create a wobbling effect for a character/sprite?

Okay, so I just tried it, as you can see in the screenshot. However, nothing is happening at all. I must have made a mistake somewhere. I will create a short video to show how it looks in-game.