sql server triggers

• elkilany_elcomanda

  Newbie

  Points: 6

  More actions

  July 5, 2010 at 2:50 am

  #140900

  Hi, I want to ask about the possibility to use an sql trigger that fires and event when a specified time passes , i mean a time-driven trigger , is that possible , and if it's possible i need some link describes how it's done

  thanks...

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  July 5, 2010 at 2:57 am

  #1188692

  You probably want to set up a SQL Agent job. Triggers are not time driven, but event driven.

  Would a job solve your issue?

  -- Gianluca Sartori

• elkilany_elcomanda

  Newbie

  Points: 6

  More actions

  July 5, 2010 at 4:04 am

  #1188720

  Actually i'm a beginner with SQL , however i've just seen how agent jobs work,

  that seems like what i need,

  it's important to say that all i need is to update some values in some tables on a specific time..

  so i'll continue with agent jobs i think..

  Thanks alot.....