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
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
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 must presume that this is what was generated when you did the "simply right click on the database etc ..."
ASKER
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
so you have to find and modify the relevant maintenance plan to change the backup destination