Static loads are loads that don't change over time. The weight of the steel framing and concrete decks in a building are examples of static loads. Static loads are sometimes referred to as "dead loads".
Cyclic loads are loads that change with time, like cars and trucks moving across a bridge deck. Wave action against a pier, rotating shafts that are out of balance so that vibrations are induced, wind loads, moving bridge cranes, etc. are example of cyclic loads. Cyclic loads induce fatigue cracks over long periods of time unless the engineer takes fatigue loading into consideration. Cyclic loads are sometimes referred to as "live loads".
Best regards - Al