What scripts do you need to get an assignment or representation?

On my way up to Seattle for the big Mariners’ home opener. Here are some Friday Questions while I wait forever in the TSA line.
Damian1342 is up first (beating out the previous 1341 Damians):

Is it possible to get a freelance or staff writing job or even manager from just a Sitcom Pilot script? As opposed to doing a traditional Spec script? Of course we are assuming here the script is good