UFN_SQLJOB_PROXYEXISTS

Return

Return Type
bit

Definition

Copy


CREATE function dbo.UFN_SQLJOB_PROXYEXISTS()
returns bit
with execute as caller
as begin

    if exists(select 1 from msdb.dbo.sysproxies where sysproxies.name like 'Blackbaud Job Proxy - ' + db_name())
        return 1;            

  return 0;
end