Delete records every day

Hi!

New on this

Is there a way on a sql sever where i can
delete som records one time every day
like if a field in my table is < getdate()

Alvin

Hi again

I have made a stored procedure there delete my records
can i run this procedure on a specfic time every day?

Alvin

|||

Hi Alvin,

You can schedule the stored procedure to run as required via creating a job (and step) in SQL Server agent.

Cheers,

Rob

|||

Hi

Can you help a bit more
i make ajob and here i select step
then i don't now what to do?

regards

alvin

|||

Hi again

in setp i can't see what type i shall use.
and then run as

So please help here

alvin

|||

i have done it

thanks

alvin