hi guys i want to create a job in SQL 2000. this job is supposed to help me delete data every month. i want to keep data that is for the past three month all the time.
i have a stored proc that deletes data less than a date i enter. my question is can i use this SP in the step for the job i want to create? if so how do i go about it. how will the job know which date to delete since right now i enter the date when i run the SP. NOVICE to SQL