I am New. here in jeddah

Welcome everyone
I am from the USA
I work with Saudi Aramco
I want to live in Sherbatly compound for only two months Can I get two months
After that I'll go to Dubai

Call the compound and inquire about it, but I think it's a very slim chance since they have a long waiting list of people who wants to rent there for long stay not only two months.

Another idea is to state your dates here and maybe (just maybe) someone how is already living there is looking for someone to share the space and cost with ( it works with me few times before when I was looking to live in a compound). Since many people who lives in compounds are having  their companies paying  for it directly to the compounds and they are looking to cash-on some of their accommodation allowances, so it could work for both.

Its hardly unlikely that compound will do a contract for only 2 months.
your best option as stated by ahmadaq is to share accommodation with someone already living there.
why you not living in Aramco compound?

Aramco compound There is no vacant place
will be a transition to Dammam, after two months