scheduling sql script

• bruce_reid

  SSCrazy

  Points: 2419

  More actions

  May 5, 2003 at 6:05 am

  #175600

  I have a sql script( not a stored procedure) which should run daily at 10 pm.How can i schedule the script to run everyday et that time.

  Thanks.

• Antares686

  SSC Guru

  Points: 125444

  More actions

  May 5, 2003 at 6:35 am

  #456129

  Create a job in SQL Agent, just paste your Script into a step and set a scheduled time.