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...

I've got a few minutes to look into this, so I took the time. This time I ran another job which I know is supposed to send out an email...

OK, I found the problem, and it wasn't with the database. Actually, running SQL Profiler, indirectly, pointed to what was wrong. As I said previously I couldn't find an INSERT...

Hello Kevin,

I've finally had a chance to give your suggestion a try. I got SQL Profiler running, but here's what it gave me:

exec sp_executesql N'UPDATE [ASISubstanceUse] SET [ClientNumber] = @ClientNumber,

[CaseNumber]...

We had to move SSRS to a different server.

That's great idea, liteswitch and JeremyE. I've just setup a simple job to do a SELECT '1', put a notification onto it and it will fire in 10 minutes. Will...