It was written for the show and is not titled anything other than "30 Rock Theme Song". It was written by Jeff Richmond, who is Tina Fey's husband in real life.
The Rock sings his own entrance theme. If you listen to the beginning of his song, it says "If you can smell what the rock is cooking" specifically spoken in the words of the rock himself.