Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 314
  • Last Modified:

Modify the name of job schedule

Hello,

How can I modify the name of job schedule in T-SQL?

Thanks

Regards

bibi
0
bibi92
Asked:
bibi92
  • 3
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
0
 
bibi92Author Commented:
Hello,

I have to change the name of the schedule but not the name of the job.

Thanks

Regards

bibi
0
 
bibi92Author Commented:
Hello,

I have found sp_update_schedule
    {   [ @schedule_id = ] schedule_id
      | [ @name = ] 'schedule_name' }
    [ , [ @new_name = ] new_name ]
    [ , [ @enabled = ] enabled ]
Thanks
bibi
0
 
bibi92Author Commented:
sp_update_schedule
    {   [ @schedule_id = ] schedule_id
      | [ @name = ] 'schedule_name' }
    [ , [ @new_name = ] new_name ]
    [ , [ @enabled = ] enabled ]
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
sorry for the misunderstanding ...
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now