Link to home
Start Free TrialLog in
Avatar of dankyle67
dankyle67

asked on

sql server agent job editing selection

Hi,
I have a backup job in sql server 2008 that is listed on sql server agent jobs list in sql studio manager and wanted to know how i can edit it within properties so i can change the target to reflect a different backup location.  I dont seem to see it anywhere as an option.  i can see schedule option to edit schedule of job but nothing for target.  thanks
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

the backup is managed in the Maintenance plan, the job will just "execute" that maintenance plan.
so you have to find and modify the relevant maintenance plan to change the backup destination
Avatar of dankyle67
dankyle67

ASKER

I didnt set it up under a maintenance plan originally.  I simply right clicked the database i wanted to backup and selected backup and went through steps to set up the schedule and target location and other options etc.  Doesnt make sense that you can edit the sql server agent job for the schedule of the job but not the target.
ok, but is there a maintenance plan for that backup?
I must presume that this is what was generated when you did the "simply right click on the database etc ..."
I set up all the backups in sql studio manager this way without ever going into maintenance plan.  I checked but there is no maintenance plan set up.  I was actually advised by a sql admin that you dont have to use the maintenance plans but instead use sql agent to run and schedule all backup tasks.  I can just delete the current jobs and set up a new one for each of the 4 jobs i require but i was more curious on why you wouldnt be able to edit these jobs in properties section.  
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial