Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
a Kron kinda job
- Thread starter onressy
- Start date
ptheriault
IS-IT--Management
Yes, execute the stored procedure from a scheduled job.
From Management Studio
Expand SQL Server Agent.
Right Click on Jobs and select new job.
on the steps page select new step and add your command in the command window.
exec <sp_name>
Make sure you have selected the correct database where the sp is located.
Add the schedule to run every 10 minutes.
From Management Studio
Expand SQL Server Agent.
Right Click on Jobs and select new job.
on the steps page select new step and add your command in the command window.
exec <sp_name>
Make sure you have selected the correct database where the sp is located.
Add the schedule to run every 10 minutes.
- Status
Similar threads