Microsoft SQL Server
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community Forums > Databases > Microsoft SQL Server
Reload this Page

Time driven sp

Discuss Time driven sp in the Microsoft SQL Server forum on Dev Articles.
Time driven sp Microsoft SQL Server forum discussing this extremely popular DBMS for the Windows operating system. Learn to optimize your SQL Server database for optimum application performance.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old April 11th, 2007, 02:24 AM
prema_mca prema_mca is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Apr 2007
Posts: 1 prema_mca User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 5 m 16 sec
Reputation Power: 0
Time driven sp
Can anyone tell how to execute a sp with respect to time. ( for ex, the sp should be executed at 12 AM irrespective of system shut downs or log offs)
Its an urgent requirement
Reply With Quote
  #2  
Old May 21st, 2007, 02:18 AM
ABHI_developer ABHI_developer is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: May 2007
Posts: 4 ABHI_developer User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 5 m 17 sec
Reputation Power: 0
Quote:
Originally Posted by prema_mca
Can anyone tell how to execute a sp with respect to time. ( for ex, the sp should be executed at 12 AM irrespective of system shut downs or log offs)
Its an urgent requirement


Follow the given
(URL address blocked: See forum rules)
(URL address blocked: See forum rules)
i think it me solve u r problem
Reply With Quote
  #3  
Old May 21st, 2007, 02:19 AM
ABHI_developer ABHI_developer is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: May 2007
Posts: 4 ABHI_developer User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 5 m 17 sec
Reputation Power: 0
sql server
Quote:
Originally Posted by prema_mca
Can anyone tell how to execute a sp with respect to time. ( for ex, the sp should be executed at 12 AM irrespective of system shut downs or log offs)
Its an urgent requirement


Follow the given
(URL address blocked: See forum rules)
i think it me solve u r problem
Reply With Quote
  #4  
Old May 21st, 2007, 02:34 AM
ABHI_developer ABHI_developer is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: May 2007
Posts: 4 ABHI_developer User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 5 m 17 sec
Reputation Power: 0
Quote:
Originally Posted by ABHI_developer
Follow the given
(URL address blocked: See forum rules)
(URL address blocked: See forum rules)
i think it me solve u r problem


u have to use job scduling in sql server
Reply With Quote
Reply

Viewing: Dev Articles Community Forums > Databases > Microsoft SQL Server > Time driven sp

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 5 hosted by Hostway. 
Stay green...Green IT