I fixed the problem part....Just joined with another table....Please review it...It is ok now...
FROM msdb..sysjobschedules x, msdb..sysschedules y
WHERE x.schedule_id = y.schedule_id
and job_id = @jobID
Rabia
------------------------------------------------------------------------
-- Name ...