Hi Ruben12345,

SQL Server Express doesn't include SQL Server Agent, so it's not possible to just create SQL Agent jobs. What you can do is you can create jobs manually by Windows Task Scheduler.

Refer the below article.

Automatically send Birthday email using C# and VB.Net

Hi dharmendr..

thanks for ur information,.

i can figure it out, but i still try for creating task manually for running my store procedure ,

i have create the task with code , and when i execute the query is start but never stop, may be i have miss parameter for stop it..

i gave some sample code for my sql job

thanks

USE [InovatrackVTS]
GO
/****** Object:  StoredProcedure [dbo].[Task_Shipment_Assignment]    Script Date: 7/6/2017 9:17:28 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[Task_Shipment_Assignment]
AS
BEGIN

    SET NOCOUNT ON;

    DECLARE @timeToRun nvarchar(50)
    set @timeToRun = '12:00:00'

    while 1 = 1
    begin
        waitfor time @timeToRun
        begin
            execute [InovatrackVTS].[dbo].[sp_shipment_assignment];
        end
    end
END

Refer below link.

https://social.msdn.microsoft.com/Forums/en-US/6084d94f-0a7a-401c-a394-1b019c72039b/how-to-stop-while-loop-when-getting-the-desired-output?forum=transactsql

Hi dharmendr

thanks For ur information..

it works