A few things to notice:

1) (regarding your question)

The problem is with @entrydateconv = DATEADD(day,-29,getdate()) .

Since you "normalized" @entrydateconv, your WHERE condition will only be true exactly at midnight for each day.

You should change it to

@entrydateconv = dateadd(dd, datediff(dd,0, GetDate() ),-29)

2) question in general

You should change your syntax when joining tables.

Instead of

FROM dbo.NOTE_tblNote n, dbo.ICOMP_tblEmployee i, XCOMP_tblCompany x, CON_tblContact c

WHERE

n.employeeid = i.employeeid

and n.companyid = x.companyid

and n.contactid = c.contactid

I'd recommend

FROM dbo.NOTE_tblNote n

INNER JOIN dbo.ICOMP_tblEmployee i ON n.employeeid = i.employeeid

INNER JOIN XCOMP_tblCompany x ON n.companyid = x.companyid

INNER JOIN CON_tblContact c ON n.contactid = c.contactid

3) and finally:

What is the specific reason to use a cursor?

I strongly recommend to try to change your cursor into a set-based approach to help performance.