sql server 2005 - SQL - Raise error in Sproc when the select result set is empty -

i trying execute stored procedure within sql job step (sql server 2005).
want raise error , fail job step when result set of stored procedure executing not empty.

what stored procedure --i have select statement rows displayed if current date equal date in 1 of columns of table.

select  holiday_date tblholidays   convert(varchar(10),getdate(),101) = convert(varchar(10),holiday_date,101) 

if result set empty, want succeed job step , proceed next job step.

any thoughts on how working.

thanks

you can try raiserror althought can't remember if cause whole job fail, if try 1 of warning severity levels.

if @@rowcount > 0   raiserror ('found data', 16, 1)