i think you declare parameters before As in store procedure. See following updated sp
CREATE PROC sp_Temptable1_Update
@id smallint,
@fname varchar(10),
@age smallint,
@email varchar(25),
@status varchar(10),
@job varchar(10)
AS
BEGIN TRAN
UPDATE Temptable1 SET Fname = @fname, Age = @age, Email = @email, Estatus = @status, Job = @job
WHERE Id = @id
IF @@ERROR <> 0 GOTO Error
COMMIT TRAN
Error:
IF @@TRANCOUNT <> 0
ROLLBACK TRAN