how can i avoid sql job to fail when i am using raise error in sql agent job
i am using simple raise error but as soon as it raises error ,sql job also fails...,is there any way i can avoid sql job failure after error is raised?
if exists
(select * from name)
Begin
RAISERROR ('Issue', -- Message text.
16, -- Severity.
1 -- State.
)