Vladan's example is probably going to be the best example, if you want to keep everything in one single SQL statement.

In general you want to avoid using functions in WHERE...

Yeah, I'm not sure what the problem is really.  There is a run_status field in sysjobhistory but it doesn't get populated until the job finishes, which defeats the purpose of...

Leo,

good article.  However, there is an issue with your use of the sysjobhistory table.  You mention, near the end of your article, that if we want to check on jobs...

I've seen this error before and although it could be various things in my case it was always that SQL Server was not listening on shared memory.  The fact that...

If I have understood your problem correctly, what you need to do is to encapsulate all three of your steps into a single transaction and ensure that you lock the...

If you can't find anything on http://www.sqldts.com try this....  Schedule the DTS package so that it creates a SQL job for you and then make sure that you disable...

Looks like that would work, although I'd rather use a TABLOCKX to be certain.  I'd also write it out slightly differently.

BEGIN TRAN

DECLARE @NextReference int

--taking out the exclusive lock here ensures...

quote:

---

Declare @ReturnDate Datetime

Select @ReturnDate = fn_SomeFunc(@SomeArg)

If (@ReturnDate = '1 Jan 1900')

-- Error Returned, Rollback etc.

Else

-- Commit Transaction

---