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
 SQL Server 2005 Forums
 Transact-SQL (2005)
 How do i Schedule a SP or function

Author  Topic 

mary_itohan
Posting Yak Master

191 Posts

Posted - 2008-08-30 : 04:55:13
Hello,
How do i Schedule a SP or function to run at at particular time.

I want this automated that once a user calls the function. It runs at that particular time variable

thanks
M






Yes O !

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-30 : 05:11:28
You can create a SQL job in sql server agent to execute the SP/function. then schedule the job to process according to your convienience. search for sql agent jobs in books online for more details.
Go to Top of Page

mary_itohan
Posting Yak Master

191 Posts

Posted - 2008-08-30 : 06:19:52
Its a shared DB and we dont have access to the sql server agent.

Are there other ways ?

Yes O !
Go to Top of Page
   

- Advertisement -