Updating JobSchedule in SQL Server 2000
exec sp_update_jobschedule @job_id='E9814833-7715-4BEE-B646-E286EBC33DE8', @name = 'Centrailised Database Backup Job - From 41.48 to 41.41 E Drive',---This name comes from sysjobschedules table @new_name='We can give any name here instead of Daily,Weekly'--As per our intention. @enabled =1, @freq_type = 8, @freq_interval =64, @freq_recurrence_factor=1