scheduling stored procedure

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Frank Kalis SSC Guru Points: 111183 More actions · Answer 1

Create a job

Add a step

Name it what you like

type Transact-SQL Script

choose appropriate db

type 'EXEC sp_name'

schedule it to run daily at your time

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

hep1 Say Hey Kid Points: 709 More actions · Answer 2

enterprise manager - create a local package.

add SQL task and connection to approprite db.

type 'exec proc_name' in sql statement task

right click on package and schedule.

you can then modify job in sql server agent jobs tab.

bruce_reid SSCrazy Points: 2419 More actions · Answer 3

SSCrazy

Points: 2419

May 28, 2003 at 9:48 am

thanks all of you