Psalm 122 is the 122nd psalm from the Book of Psalms. It is one of 15 psalms that begins with the words "A song of ascents" (Shir Hama'alot).

The text:
Psalm 122

A song of ascents. Of David.


I rejoiced with those who said to me,

“Let us go to the house of the LORD.”

Our feet are standing

in your gates, Jerusalem.


Jerusalem is built like a city

that is closely compacted together.

That is where the tribes go up—

the tribes of the LORD—

to praise the name of the LORD

according to the statute given to Israel.

There stand the thrones for judgment,

the thrones of the house of David.


Pray for the peace of Jerusalem:

“May those who love you be secure.

May there be peace within your walls

and security within your citadels.”

For the sake of my family and friends,

I will say, “Peace be within you.”

For the sake of the house of the LORD our God,

I will seek your prosperity.

Judaism

• Is recited following Mincha
  Mincha
  Mincha, מנחה is the afternoon prayer service in Judaism.-Etymology:The name "Mincha" is derived from the meal offering that accompanied each sacrifice.-Origin:...
  
   between Sukkot
  Sukkot
  Sukkot is a Biblical holiday celebrated on the 15th day of the month of Tishrei . It is one of the three biblically mandated festivals Shalosh regalim on which Hebrews were commanded to make a pilgrimage to the Temple in Jerusalem.The holiday lasts seven days...
  
   and Shabbat Hagadol.
• Is recited on Shabbat Nachamu (the Shabbat after Tisha B'Av
  Tisha B'Av
  |Av]],") is an annual fast day in Judaism, named for the ninth day of the month of Av in the Hebrew calendar. The fast commemorates the destruction of both the First Temple and Second Temple in Jerusalem, which occurred about 655 years apart, but on the same Hebrew calendar date...
  
  ) in some traditions.
• Verses 7-9 are part of Talmud Berachos
  Berakhot (Talmud)
  Berachot is the first tractate of Seder Zeraim, a collection of the Mishnah that primarily deals with laws relating to plants and farming...
  
   64a.

Other

• The Vulgate
  Vulgate
  The Vulgate is a late 4th-century Latin translation of the Bible. It was largely the work of St. Jerome, who was commissioned by Pope Damasus I in 382 to make a revision of the old Latin translations...
  
   version, Laetatus sum, is used in Monteverdi's Vespers
• The Book of Common Prayer
  Book of Common Prayer
  The Book of Common Prayer is the short title of a number of related prayer books used in the Anglican Communion, as well as by the Continuing Anglican, "Anglican realignment" and other Anglican churches. The original book, published in 1549 , in the reign of Edward VI, was a product of the English...
  
   version, I was glad
  I was glad
  I was glad is an introit commonly used in the Anglican church, and also used as an anthem traditionally sung at the coronation of British monarchs...
  
  , is used in Parry
  Hubert Parry
  Sir Charles Hubert Hastings Parry, 1st Baronet was an English composer, teacher and historian of music.Parry's first major works appeared in 1880. As a composer he is best known for the choral song "Jerusalem", the coronation anthem "I was glad" and the hymn tune "Repton", which sets the words...
  
  's 1902 coronation anthem. The same text was used for coronation music by Purcell
  Henry Purcell
  Henry Purcell – 21 November 1695), was an English organist and Baroque composer of secular and sacred music. Although Purcell incorporated Italian and French stylistic elements into his compositions, his legacy was a uniquely English form of Baroque music...
  
  and others.