How to run a stored procedure on a daily /weekly/monthly basis?
In SQL Server, you should use JOBS to run a stored procedure based on schedule. Open SQL Server Management Studio. Expand SQL Serve Agent. Right-click on jobs and select a new job. Provide a name for the job and description. Click on the steps option> click new. Write the name of the step. Select the type of… Leer más »