• JackIntheBox (1/2/2014)


    Try this,

    It will tell you the current status and last Execution and future execution times.

    USE [msdb]

    sp_help_job

    Thank you, that's very helpful! I've just run the sp_help_job SP in msdb per your suggestion. Since I ran my SQL Job manually earlier, it indicated that, so no surprise there. It indicates that the next scheduled run job is 2/1/2014 (US time designation) at 500, which I take to mean 5 minutes past midnight. That date is certainly not the date I want it to run at. Does it start at the time, and then determine that it's the wrong date, and then goes back to sleep until 3/1/2014? Or is that really the next date that it will run the SQL Job to completion?

    Addendum: I've already got this SQL Job set up to send me an email if it fails (I put that into the notifications), and that's the way I want it, but is there also a way to have it send me an email on it completes, too?

    Kindest Regards, Rod Connect with me on LinkedIn.