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

x
?
Solved

sql server agent job editing selection

Posted on 2011-10-13
5
Medium Priority
?
308 Views
Last Modified: 2012-05-12
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
0
Comment
Question by:dankyle67
  • 3
  • 2
5 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 36962096
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
0
 

Author Comment

by:dankyle67
ID: 36962202
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.
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 36966964
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 ..."
0
 

Author Comment

by:dankyle67
ID: 36969736
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.  
0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 2000 total points
ID: 36969798
then, the config must be in the agent's job, aka in the job step details
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Screencast - Getting to Know the Pipeline

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question