May 28, 2003 at 8:19 am
How can i schedule a stored procedure to run daily at 12 am
May 28, 2003 at 8:25 am
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]
May 28, 2003 at 9:17 am
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.
May 28, 2003 at 9:48 am
thanks all of you
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply