After Insert trigger not Firing in SQL2008

See more:

SQL-Server

hi,

I my web application, I need to update 'JOB STATUS' field which was in another(JOBSHEET) table after BILLING table affected.

I use the trigger as follows...

ALTER trigger [dbo].[TR_JOBSTATUS]
on [dbo].[Billing] After INSERT
As
Begin
declare @jobchdid as nvarchar(5)

select @jobchdid = i.Jobchdid from inserted i

Update dbo.Jobsheet set
[status] = 'BILLING MADE' where
jobchd_id = @jobchdid
End