Create trigger that executes on date

[damokk]

Hi. I am creating an application that uses sqlserver and asp.net c#. I need to create a trigger that inserts data into a table 30 days before an expiry date field in another table. I have created the trigger but dont know how to implement the dates? Any suggestions would be appreciated.

[Corporal Agarn]

Does the date go in when the "expiry date" column is populate or do you want it to go in 30 days before the date?

[Mycroft Holmes]

What you are describing is not a trigger spit but a JOB, the job would call a proc that checks for expiry dates 30 days away and insert the appropriate record. You would schedule the JOB to run daily.

Never underestimate the power of human stupidity RAH

[damokk]

thanks for the reply. I had a feeling a trigger would be difficult or impossible to implement in this way.. Not sure how to create this job tho. Any pointers would be appreciated?

[damokk]

I already have a table with an appointment date entered. I need to update another table 30 days before before this appointment date. Thanks

[Mycroft Holmes]

Create a stored procedure that does the following Get the expiring records insert the relevant data into the target table. In SSMS create a Job that calls the stored proc schedule the job to run every day

Never underestimate the power of human stupidity RAH

[damokk]

thanks I'll give it a try!