How to schedule stored procedure?

• sani

  SSCrazy

  Points: 2477

  More actions

  October 23, 2004 at 1:41 am

  #162499

  Hi All,

  I want to know how can I schedule one my custom stored procedure?

  Thanks for your attention,

  Sani

• Eric1972

  Old Hand

  Points: 379

  More actions

  October 23, 2004 at 4:15 am

  #527733

  Create a job with the SQL Server Agent. See BOL for more info on how to create jobs.

• sani

  SSCrazy

  Points: 2477

  More actions

  October 25, 2004 at 12:01 am

  #527769

  thanks in advance for ur reply.

  I set the job step : exec my_sp_name and schedule this job .

  Sani