June 2, 2010 at 7:55 am
Hi,
I recently implemented database mirroring as high availability option.
Now i need to transfer all jobs to my mirror server - I know this can be done with a SSIS-"transfer jobs task". All the jobs are transfered, but the attached schedules are missing (neither created, nor attached).
I tried to build a custom task in SSIS to transfer the schedules and attach them to my transfered jobs (used sp_add_schedule and sp_attach_schedule). Unfortunately this doesn't work, because sp_add_schedule creates a new schedule_id everytime I add the schedule and sp_attach_schedule needs this schedule_id as input parameter. So it's impossible to match the transfered jobs with the newly created schedules.
Is there another possibilty to transfer jobs and schedules together?
Thank you!
-----------------------
SQL Server Database Copy Tool at Codeplex
June 2, 2010 at 8:51 am
June 2, 2010 at 2:10 pm
calvo (6/2/2010)
Might you be able to right click and script the job? Then just run the script through SSIS or run it manually on the server?good luck
Hi calvo,
for an initial transfer this would work, but I need to transfer all jobs including their schedules on a regular basis. I do not want to edit my jobs/schedules twice every time I change something.
I can't imagine to be the first with this problem, but can't find anything about it...
-----------------------
SQL Server Database Copy Tool at Codeplex
June 7, 2010 at 12:49 pm
I did a transfer using SSIS package, all jobs and their schedules transferred completely. I could see schedules attached to the jobs. I used BIDS to create package and was using SA login. Will it be possible for you try with SA?
Don't know why it did not help you.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply