Automatic record insertion depends on system date sql server 2000?

[Dotnetkanna]

Hi, Im having two tables in sql server 2000 with same structure in first table if the current sysdate is equal to first table BDate column value means the first table that current sysdate record should be automatically insert to the second table,How can i acheive this one..any suggestions... First Table: --------------- Name BDate Content ------------------------------- Kanna 12/5/2008 Hapy birthday Second Table: -------------- Name BDate Content ------------------------------- Regards Kanna

[Krish KP]

Create a job to fetch all rows from first table that matches to the current date and copies to second table Schedule the job to execute daily

Regards KP

[Dotnetkanna]

Thanks for ur reply how should i create job.. im new to this concept..can u give me the example code??? regards Kanna

[Krish KP]

From SQL Enterprise Manager, select your server instance and go to Management -> SQL Server Agent -> Jobs right click "New Job" write your SQL query under "step" then schedule the job

Regards KP