Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Job scheduling

Author  Topic 

yaman
Posting Yak Master

213 Posts

Posted - 2008-10-22 : 12:31:33
Sir
I have a Procedure and i want to run on every Night.
So
I want to make Scheduling on a procedure .

How can i Do.
Pls help me out

Yaman

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-22 : 12:48:53
Just add a job in sql agent to call this procedure and schedule it.
Go to Top of Page

sakets_2000
Master Smack Fu Yak Hacker

1472 Posts

Posted - 2008-10-22 : 12:49:01
put it in a dts, and schedule it.
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-10-22 : 13:20:09
why DTS package????
Go to Top of Page

yaman
Posting Yak Master

213 Posts

Posted - 2008-10-22 : 15:21:11
Hello

I don't know what is the step to Follow to create JOb schedule for a procedure .

Pls give me a any Link of Web site or any tutorials .



Yaman
Go to Top of Page

yaman
Posting Yak Master

213 Posts

Posted - 2008-10-22 : 16:51:44
Hello Sir,

I don't know what is the step to Follow to create JOb schedule for a procedure .

Pls give me a any Link of Web site or any tutorials .


Yaman
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2008-10-22 : 17:02:55
sql server 2000 or 2005?

No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-23 : 00:13:47
refer below

http://msdn.microsoft.com/en-us/library/ms187910.aspx
Go to Top of Page
   

- Advertisement -