Though I'd agree...

raulggonzalez (9/11/2013)

---

As somebody said, most of those complaining, run the script before answering the question which is "cheating", so they shouldn't be rewarded for cheating.

If you are giving points back,...

Despite the question having the wrong answer due to an error, I did learn something new about the ^.

A lot of the questions on here will never be...

I was just about to say, don't know what everyone is talking about, the correct answer is...

Thought this was a trick question for a minute!

L' Eomot Inversé (5/23/2013)

---

Would it not make sense to see what the start_execution_date is for these jobs, instead of (or as well as) the execution_requested_date? Also, to see what...

Sean Pearce (5/23/2013)

Right click your job in SSMS

Script Job as -->

DROP And CREATE To -->

New Query Editor Window

Execute...

Sean Pearce (5/23/2013)

---

Ross.M (5/14/2013)

---

So my questions are:

(1) What might have caused this?

(2) Is it safe to just do...

durai nagarajan (5/22/2013)

---

For example a job which runs daily and is in sysjobactivity as starting in 2010 but never finished will just show as normal for it's day to day...

I mean it doesn't...

Nope, Job Activity Monitor works fine, and it doesn't show these old jobs, but I would like to build...

I'm not talking from first hand experience, but it looks like it should be fine:

http://msdn.microsoft.com/en-GB/library/ms191304(v=sql.90).aspx

Optionally, specify:

- The INIT clause to overwrite the backup media, and write the backup as...

Thanks for the replies guys, no luck as yet though.

Restarting didn't work, the server never usually gets restarted as it is...

Good question to start the week off.

Given the available answers, the lack of an alias doesn't really matter, anyone reading the question and options to choose from should realise...

Thanks for all the info, much appreciated! I'll go with the log shipping method as like you say, I'm the most familiar with that. I have a week...