I don't really understand what your table actually looks like.

Would you please post the table def, some sample data, your expected result and what you've tried so far? For details...

So, I guess sp_help_jobhistory together with ROW_NUMBER() will help here. Please...

Please have a look at BOL (BooksOnLine, the SQL Server gelp system usually installed together with SQL Server, accessible via F1 from Management Studio). Search for the "CREATE XML SCHEMA...

Would a CHECK constraint help?

ALTER TABLE YourTable

ADD CONSTRAINT chkCol1Col2 CHECK ( ISNULL(col1,col2) IS NOT NULL );

This constraint would allow you to insert a NULL value either for Col1 or Col2...

What exactly do...

Richard M. (5/17/2010)

---

... you can't "inject" an error to another SPID....

As far...

Not sure what you're trying to do but maybe RAISERROR will help (see BOL for details).

Another strong hint: you might want to remove your email address. If people feel the need to provide you with a sample they can drop you a PM...

The requirement is not clear. Do you want to list only jobs where the last run and the one before failed, job that have failed twice (as per available log...

duplicate post.

Already answered here

neelsmail (5/16/2010)

---

> You still haven't explained what you're trying to do 10,000 times a second...

I thought I did.. but perhaps I didn't understand your question.

I am trying to call the...

So, what does that sproc do that takes 3min?

Nope, it's the other way around: you SEND a message to the Service Broker queue and within the...

I wouldn't bother with the current design and start from scratch: what are the input tables and values and what is the expected result.

Don't worry about the current DTS design...

One option:

Determine the condition when the 3min-sproc needs to be called either within your 2se-sproc or in the next step in the job agent. Based on that condition fire a...