Hi

I have created a stored procedure to insert carclassid in mstcarclass table.The stored procedure is given below.

CREATE PROCEDURE [dbo].[nishim1](@carclassid numeric(9)) AS
insert into mstcarclass(carclassid)
values(@carclassid)
GO


How I call this stored procedure through schedule task.
Actually I want that this procedure should run automatically when new day starts.

Plz give me the proper solution



Nishim Attreja

Hello Nishim,

You can do this at SQL server itself. Open enterprise manager. Login as administrator. You can create a job. Specify the type as Transact-SQL. Then set its execution time and frequency.