SQLServer Job

• abr_mah

  SSC Enthusiast

  Points: 191

  More actions

  February 18, 2009 at 8:12 am

  #130987

  dear all

  Plz Help quickly

  i want to creat ajob update value in atable in database

  example :

  update Mytable set Status=0 where Mydate < getdate() ;

  ---------------

  i want to create ajob to run this query

  thanks

• CrazyMan

  SSChampion

  Points: 12560

  More actions

  February 18, 2009 at 8:14 am

  #945967

  You can use SQL server agent, right click and add a new job and schedule to run on your preferred time 🙂

• abr_mah

  SSC Enthusiast

  Points: 191

  More actions

  February 18, 2009 at 9:27 am

  #946063

  thanx alot

  i have done it

  1- add new job

  2- add new step or more steps (write command)

  3- add new schedual

  4- finish and start job

  it works perfect

  thanks again for your interest