Running a SP everynight

[Aleks]

Hi,

I have a SP in a database which needs to be run every night, it basically
deleted all records in one table.
How can it be setup ? ...

Thanks !

Aleks

 

[nick]

I have no experience with this but it seems that's what SQL server Agent is
there for.

In Enterprise Manager use Tools - Job Scheduling... to set up the recurring
event.

 

[Aleks]

thx

I have no experience with this but it seems that's what SQL server Agent is
there for.

In Enterprise Manager use Tools - Job Scheduling... to set up the
recurring event.