What are the challenges you face when working across database platforms? Take the survey
Options

cannot edit jobs in GUI

Giggles220Giggles220 Posts: 154
edited February 22, 2008 10:14AM in SQL Backup Previous Versions
I know that if I edit the job in Management studio I may not be able to edit the job again in the GUI but I haven't editted my jobs outside of the gui and now it won't let me edit them.

Does changing the schedule in Management studio prevent one from editing the job in the GUI? This is the only thing I can think of is if my backup changed the schedule.

Comments

  • Options
    Eddie DEddie D Posts: 1,792 Rose Gold 5
    Thank you for your forum post.

    SQL Backup jobs can become uneditable and undeletable from the SQL Backup GUI if the user:

    1. Adds additional job steps in SSMS / Enterprise Manager.
    2. Uses syntax that SQL Backup does not recognise.
    3. Permissions, the logged in user using the SQL Backup GUI does not have the permissions to edit the job.

    Using SQL Backup 5.2, I am unable to reproduce you fault symptoms.

    Can you please check to ensure that the logged in user account has the necessary permissions to edit the job?

    Many Thanks
    Eddie

    Eddie Davis
    Technical Support Engineer
    Red Gate Software Ltd
    E-mail: support@red-gate.com
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • Options
    I created the job and I am the one trying to edit the job so I should have permissions.

    I didn't add any steps but I think maybe the schedule was changed in SSMS. Would this cause the problem?
Sign In or Register to comment.