Run SQL Trigger every day

**Anilrgowda** · 22-Oct-2007, 12:41 AM

Question: Dear Sir / Madam,
I have a table in SQL that contains records with some empty fields. Every end of the day, I would like to delete the records that contain these empty fields, e.g:

Delete from table where field = ''

I am not sure how to do this, whether in a trigger or a stored procedure. My issue is in scheduling this to run daily in SQL server 2000. Is it possible? and how? Thank you.

**Anilrgowda** · 22-Oct-2007, 12:42 AM

You can create a job instead

HuyBD

22-Oct-2007, 12:41 AM	#1 (permalink)
Anilrgowda Administrator Posts: 18,715 Join Date: Jan 2006 Rep Power: 10 IM:	Run SQL Trigger every day Question: Dear Sir / Madam, I have a table in SQL that contains records with some empty fields. Every end of the day, I would like to delete the records that contain these empty fields, e.g: Delete from table where field = '' I am not sure how to do this, whether in a trigger or a stored procedure. My issue is in scheduling this to run daily in SQL server 2000. Is it possible? and how? Thank you. ------------------

22-Oct-2007, 12:42 AM	#2 (permalink)
Anilrgowda Administrator Posts: 18,715 Join Date: Jan 2006 Rep Power: 10 IM:	Re: Run SQL Trigger every day You can create a job instead HuyBD ------------------

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)