Thank you vilyana, pmadhavapeddi22 and Sean for your answers. I tested it using the code that you gave, Sean, on my test database server. Works like a charm. So that's...

Since I'm a developer I have to have Visual Studio. That's essential for my job. Then because I do database development work I've got to have SSMS. We do reports...

Congratulations, Steve, the achieving 5 years with Red Gate, and thus being able to take a sabbatical! I've never worked at a company that offers its employees sabbaticals, so I...

OK, Bill, I've taken your advice....

The job is enabled.

Jeffrey Williams 3188 (1/2/2014)

---

You can also find the next scheduled run from the Job Activity Monitor. Open that - and you will see a column for 'Last Run' and...

Jeffrey Williams 3188 (1/2/2014)

---

Edit the schedule on the job - you should see a section for Duration. In that section, you will have a Start date - for this...

Thank you, that's very helpful! I've just run the sp_help_job SP in msdb...

Bill (DBAOnTheGo) (1/2/2014)

---

I would just right click the job, go to schedules, select the schedule, and hit edit.

See if the schedule type is listed as recurring, see if the Enabled...

Hi Bill,

I think it's been moved. I'm looking at it now in SSMS. The schedule is there, with the name that I gave it ("Beginning of Quarter"). It's in the...

Steve,

At the end of this podcast you mentioned again, that you'd be stopping the video podcast. Or at least cutting back on it. You also said that you'll be starting...

batgirl (12/13/2013)

---

In fact, my husband and I are giving ourselves a trip to the west coast to spend the holidays with his family - it will be his first time...

My list is very practical. I'd like an MSDN Premium Subscription. I think I may need it.

WOW, I think that was it! I didn't know that you could right-click on Database Mail to get anything. Sure enough, that's what I did and there was lots of...

Well, I've got to admit that I haven't performed a test message in a while. I just did, and the email never came to me. I even checked my junk...