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 2000 Forums
 SQL Server Development (2000)
 Auto search in database

Author  Topic 

vikaspa
Starting Member

3 Posts

Posted - 2003-09-01 : 14:38:14
Can I set timer so that i can regularly seach in data for certain detailes based on certain criteria (Date of birth)Every day

So that I can send a Greeting (Happy Birth day)
to my client without wasting my time in executing a dedicated program for the same

nr
SQLTeam MVY

12543 Posts

Posted - 2003-09-01 : 15:23:57
Create a scheduled job to execute a stored proc.

See under management, sql server agent, jobs in enterprise manager.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -