C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Reviews   Communities   Interview   Jobs   Projects   Training   Your Ad Here    
Silverlight Games | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Polls | Revenue Sharing | Lobby | Gift Shop |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...






Forums » .NET » SQL Server »

How to make schedular in Ms-Sql


Posted Date: 30 Aug 2008      Posted By: Nitin Kumar Sharma      Member Level: Silver     Points: 1   Responses: 2



hii i want to create a schedular in ms-sql which shold run on a predefined time of each month can any one tell me how to add schedular in ms-sql,i know it is possible.




Responses

Author: Pradeep Kumar Chaudhary    30 Aug 2008Member Level: GoldRating: 2 out of 52 out of 5     Points: 5

This type of permission should be given by the hosting company.
Example tasks:
Daily purchases/trades- Customer schedules a transaction that will run daily on a specified time based on certain rules eg the purchase/trade has to meet a certain price point or quantity.

A weekly trade will run once a week and follow the same rules as above.

The service has to run off the website /server with no offline application as is our current service.

You can download the script from the website:
http://www.codeproject.com/

Regard,
Pradeep



Author: Venkatesan Prabu .J    31 Aug 2008Member Level: DiamondRating: 2 out of 52 out of 5     Points: 1

You have to create jobs to schedule a particular process.

Regards,
Venkatesan Prabu .J



Post Reply

 This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.


Next : Arithmetic overflow error converting numeric to data type money. In SqlServer2005
Previous : SQL SERVER
Return to Discussion Forum
Post New Message
Category: SQL Server

Related Messages



dotNet Slackers

About Us    Contact Us    Privacy Policy    Terms Of Use