HI, I have a StoredProcedure already created but i need to..

Question

Hi, I need to execute a Store_Procedure only one time at month, where i have tu put it? I´m workin in a Microsoft SQL SERVER 2012 Management Studio environment

 

Thank

 

Create Procedure Mantenimiento_Tablas

as

begin

USE [Base Comunicación]

GO

DELETE FROM [dbo].[MCM_JOB]

USE [Base Comunicación]

GO

DELETE FROM [dbo].[HST_HST]

--USE [Base Comunicación]

--GO

DELETE FROM [dbo].[EVT_EVENT]

--USE [Base Comunicación]

--GO

DELETE FROM [dbo].[VFS_AFV]

--USE [Base Comunicación]

--GO

DELETE FROM [dbo].[VFS_FILE]

--USE [Base Comunicación]

--GO

DELETE FROM [dbo].[VFS_INTTRES]

 

end