hi all...i have a Stored Procedure and i want to schedule it to get executed everyday in SQL Server2000..... can anyone tell me how to schedule it ...please suggest me an approach to get started with my work....thanks for any help...
-
-
Hi,
add a job to run the Stored proc as Schedule task
1) create new job,
2) add a step to created job
3) Add name for this step, such as "Step1"
4) Choose type: Transact-SQL script
5) Choose actual database from list
6) Add command:
EXEC sp_yourstored_p roc_name
7) Go to schedules tab and set correct schedule plan -
Thanx a lot...it was helpful....Comment
Comment