• elhelalaoui (5/5/2014)


    Hello,

    Sorry for the delay, I had personal difficulties so I could'nt do this test.

    I've just launched that query and it appears that it goes well (Message : Job 'Test' started successfully.), but no email was generated :ermm:

    Must I du something else ?

    Thanks. 🙂

    Create a job and within a TSQL Job step use this command

    USE msdb ;

    GO

    EXEC dbo.sp_start_job N'Job_Name' ;

    GO

    Let the job run under your account i.e Owner of the job ..

    --

    SQLBuddy