Solved

Copy database wizard and have this as schedule

Posted on 2010-08-19
3
275 Views
Last Modified: 2012-05-10
I just created copy database job viw copy database wizard, I also have created a schedule for this which the option comes in the wizard itself, upon click nexct and finish. I couldnt found this job/task, so where can I find it ??
0
Comment
Question by:motioneye
  • 2
3 Comments
 
LVL 7

Expert Comment

by:Cboudroz
ID: 33474662
it's not under SQL server agent job?


Management Studio / object explorer / connect to your server /last icone on the bottom "SQL server Agent" /  job


0
 
LVL 2

Accepted Solution

by:
rajeshprasath earned 500 total points
ID: 33476212
you can able to see the job in destination server's SQL server agent job. It will be in the name of
CDW_ Source Server Name _  Destination Server Name _0

login to destination / target server's sql server, then go to Management Studio / object explorer / Your target Server Name /last icon on the bottom "SQL server Agent" /  job
0
 
LVL 2

Expert Comment

by:rajeshprasath
ID: 33476229
CDW_ stands for Copy Database Wizard. So search for jobs start with CDW_ in target / destination server sql server agent.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
separate column 24 20
SQL Server 2012 Row Selection 2 30
Slow SQL query 12 27
SQL - Join 2 Tables Based on Ranges 8 10
Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

759 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now