job in SQL

Hi..

I am working with an auction site ...I want to ask what I will use to open and close an auction

where the start and end date for the auction is stored in SQL server table...

I read many artical ..I think I will use job ?

can any one help me?

Hi, I'm not very clear about your requirment. Just some questions:

What's the meaning of 'open and close an auction'? Usually such business logic is implemented in application, and we use databases to manage the data, right? Do you mean you have an application to 'perform the auction', and you want to use SQL job to schedule it according to the date stored in some table, so that auctions can be automately opened and closed? Sadly to say it's too complex to use SQL job to do this; while much easier to use an application to control it--your application reads the start/end date from database table, then performs the auction process during the time between start/end date.

|||

Hi..

Tank you for reply ...I have an auction site ... the auction will start in the start date that auctioneer decide it( the start date is store in SQL server table when auctioneer create it)...when the auction start it allow the user to bid on it until the end date then the auction will close and it will determine winner that have the highest bid...

what I use to mange opening & closing auction????

|||

Seems you need a project to do this... Other than the 'start time' and 'close time', the auction can also be closed under some conditions: e.g. if some one gives highest price and no one follows up, the auction is finished. So you have to build a project to implement the business of auction; SQL can be used to stored data as backend.

sql