force error in stored procedure

[anorthcote]

I have two jobs running on my server that import data to my database. The first step of the first job writes a value to a table when it starts and removes that value when it ends correctly.

I need the second job to test if a value exists in the table and error if there is a value there.

So what I need help with is writing a stored procedure that I can run as step 1 of the job that I can force to error if a value exists so I can set the job to 'quit with failure' on failure of the step.

Does that make sense?

 

[mrdenny]

Yes that makes sense. This is done with the RAISERROR command (with only one E).

RAISERROR ('Your Message', 16, 1)
GO

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog