Bug in Task

Hi all,
I have a job that run 3 task. The first one do a backup, the second one copy those backup files from one drive to another drive, the third one supposed to delete the backup from the first drive. What is happening is as soon as the second task start the third task also start for some reason, it does not wait for all the backup files to be moved, so i end up with one backup file being copied on the second drive (locking the backup file) but all the other backup get deleted except for the lock file. Has anyone encounter the same problem? is there a way i can set up the third task not to start until the second is completed?

axel_2005 wrote:

Hi all,
I have a job that run 3 task. The first one do a backup, the second one copy those backup files from one drive to another drive, the third one supposed to delete the backup from the first drive. What is happening is as soon as the second task start the third task also start for some reason, it does not wait for all the backup files to be moved, so i end up with one backup file being copied on the second drive (locking the backup file) but all the other backup get deleted except for the lock file. Has anyone encounter the same problem? is there a way i can set up the third task not to start until the second is completed?

Do you have any precedence constraints (i.e. blue, red or green lines) between your tasks?

-Jamie

|||the tasks are link by the green arrow|||That's weird. Have you messed with the precedence constraints? When you draw a green arrow between task, by default a 'upon success' precedence is created. Just to make sure, check the options of the precedence constrains by double clicking the green arrow between the 2nd a 3rd task.|||I found a work around. Apparently when the task copy files from one place to another, it somehow return a success even though it did not copy all the files (i would say as soon as it copy the first file) so I removed the maintenance clean up and added another step to delete the files in task 3, that way only when the first step is done it will go to the next step. Thanks for your help.

Bug in ProtectionLevel?

Hi all,

I am trying to start a package as a job and this does not work...

Referring to http://support.microsoft.com/?kbid=918760 I have checked the certain settings and I do not have set the ProtectionLevel to another setting then "DontSaveSensitive" - but my default setting in the template is "with encryption"

While starting the package from the package store using the technical user which is also used for the different service accounts all works fine.

After I created a NEW package and have set ProtectionLevel to DontSaveSensitive before doing any other step it works well also being started as a job...

BTW:
Copying objects from one package to another is really a big mess!
Is there hope that this issue will be solved shortly?

any hints why the new package works well?

cheers
Markus

Markus Fischer wrote:

Hi all,

I am trying to start a package as a job and this does not work...

Referring to http://support.microsoft.com/?kbid=918760 I have checked the certain settings and I do not have set the ProtectionLevel to another setting then "DontSaveSensitive" - but my default setting in the template is "with encryption"

While starting the package from the package store using the technical user which is also used for the different service accounts all works fine.

After I created a NEW package and have set ProtectionLevel to DontSaveSensitive before doing any other step it works well also being started as a job...

BTW:
Copying objects from one package to another is really a big mess!
Is there hope that this issue will be solved shortly?

What exactly is the issue?

If you want something improved then mentioning it on here will not get it done. you need to request it at Microsoft Connect.

Markus Fischer wrote:

any hints why the new package works well?

cheers
Markus

I'm guessing that you don't have any password stored in your package. Am i reght?

-Jamie

|||

Hi Jamie,

the "thing" is, that the package does not seem to recon my change of settings regarding the ProtectionLevel.

Otherwise the the fact that the first package does not run but the second does wouldn′t be explainable...

I do not have passwords stored in the package because I am using the Integrated Security in the connections.

Shouldn′t starting the package from the package store using the technical user proof, that the package with the technical user should also work started as a job?

cheers
Markus

|||

If you are using integrated security then there are no passwords stored in the package so it will run fine under DontSaveSensitive (assuming of course that the user has access to all the external sources).

Put simply, if there are no passowrds then there is nothing to be encrypted.

Being able to execute the package manually doesn't prove anything about running it from a job if SQL Server Agent is running as a different user.

-Jamie

|||

Jamie,

to summarise it:

- the technical user has access to all external sources
- there are no passwords used
- the technical user is the one also used for the service
- the technical user also is administrator

I did not have set the ProtectionLevel to DontSaveSensitive in the first steps, after doing it it also did not run as a job.

After building my package from scratch with first step setting the ProtectionLevel to DontSaveSensitive it now works well though I presume that there is a bug in this setting

Thanks for your assistance!

cheers
Markus

BUG - SQL Agent Jobs - SP3 - Multiple Steps

I have come across what seems to be a bug in SQL 2K SP3.
When I have a job with multiple job steps and I right-click to choose which step I want to start with, the job steps are in no particular order.
I am also using an ActiveX script that uses SQLDMO to script out the jobs to a text file. When the job is scripted, it puts the job steps in what seems like alphabetical order by step name and not in step number order. If you try to run this script to c
reate the job, it will fail because it requires the job steps to be in step number order.
I have talked to others that have used this script prior to SP3 so it seems to only have occurred in this Service Pack.
I just wanted to get this information out there so it can be addressed and corrected in either a patch or at least the next SP.
This is indeed a known bug for SQL2000. Its because sp_help_jobstep doesn't
contain an order by when returning results IIRC. Generally you get the right
result but without the order by its not guaranteed
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"hawg" <anonymous@.discussions.microsoft.com> wrote in message
news:6115B24E-5496-49CB-ABCC-864C14E56DC1@.microsoft.com...
> I have come across what seems to be a bug in SQL 2K SP3.
> When I have a job with multiple job steps and I right-click to choose
which step I want to start with, the job steps are in no particular order.
> I am also using an ActiveX script that uses SQLDMO to script out the jobs
to a text file. When the job is scripted, it puts the job steps in what
seems like alphabetical order by step name and not in step number order. If
you try to run this script to create the job, it will fail because it
requires the job steps to be in step number order.
> I have talked to others that have used this script prior to SP3 so it
seems to only have occurred in this Service Pack.
> I just wanted to get this information out there so it can be addressed and
corrected in either a patch or at least the next SP.

BUG - SQL Agent Jobs - SP3 - Multiple Steps

I have come across what seems to be a bug in SQL 2K SP3.
When I have a job with multiple job steps and I right-click to choose which
step I want to start with, the job steps are in no particular order.
I am also using an ActiveX script that uses SQLDMO to script out the jobs to
a text file. When the job is scripted, it puts the job steps in what seems
like alphabetical order by step name and not in step number order. If you
try to run this script to c
reate the job, it will fail because it requires the job steps to be in step
number order.
I have talked to others that have used this script prior to SP3 so it seems
to only have occurred in this Service Pack.
I just wanted to get this information out there so it can be addressed and c
orrected in either a patch or at least the next SP.This is indeed a known bug for SQL2000. Its because sp_help_jobstep doesn't
contain an order by when returning results IIRC. Generally you get the right
result but without the order by its not guaranteed
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"hawg" <anonymous@.discussions.microsoft.com> wrote in message
news:6115B24E-5496-49CB-ABCC-864C14E56DC1@.microsoft.com...
> I have come across what seems to be a bug in SQL 2K SP3.
> When I have a job with multiple job steps and I right-click to choose
which step I want to start with, the job steps are in no particular order.
> I am also using an ActiveX script that uses SQLDMO to script out the jobs
to a text file. When the job is scripted, it puts the job steps in what
seems like alphabetical order by step name and not in step number order. If
you try to run this script to create the job, it will fail because it
requires the job steps to be in step number order.
> I have talked to others that have used this script prior to SP3 so it
seems to only have occurred in this Service Pack.
> I just wanted to get this information out there so it can be addressed and
corrected in either a patch or at least the next SP.

Buffer Latch error

I have a backup database job that failed with the following error on sql server 2005

Executed as user: TestUSer. Time-out occurred while waiting for buffer latch type 3 for page (1:10541989), database ID 8. [SQLSTATE 42000] (Error 845) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.

Does anyone know why this happened? Is it the server or the array?

Any help is appreciated.

Thanks

Check your database storage for hardware errors (disk failures, fibre connection, I/O errors, etc) This was a bug on SQL 2000 and 7.0, solved with a service pack. But i guess this is not the answer here. So, please check your equipment 1st.

Brainbench test questions

Hi,
I've been asked to take a brainbench test before an interview for a great
job. Does anyone know where I can find some test questions to practice with?
Thanks a bunch.
SusanSusan
What does mean "great job"? DBA or what?
"Susan Cooper" <SusanCooper@.discussions.microsoft.com> wrote in message
news:53057DE9-77E0-4E6F-BF5D-E450B6544990@.microsoft.com...
> Hi,
> I've been asked to take a brainbench test before an interview for a great
> job. Does anyone know where I can find some test questions to practice
> with?
>
> Thanks a bunch.
> Susan|||Sorry... great job means a senior DBA with a government agency.
"Uri Dimant" wrote:
> Susan
> What does mean "great job"? DBA or what?
>
> "Susan Cooper" <SusanCooper@.discussions.microsoft.com> wrote in message
> news:53057DE9-77E0-4E6F-BF5D-E450B6544990@.microsoft.com...
> > Hi,
> >
> > I've been asked to take a brainbench test before an interview for a great
> > job. Does anyone know where I can find some test questions to practice
> > with?
> >
> >
> > Thanks a bunch.
> > Susan
>
>|||Here you go
http://vyaskn.tripod.com/iq.htm
Good luck
"Susan Cooper" <SusanCooper@.discussions.microsoft.com> wrote in message
news:B466C086-EF06-4E32-B04F-C833072E9CDE@.microsoft.com...
> Sorry... great job means a senior DBA with a government agency.
> "Uri Dimant" wrote:
>> Susan
>> What does mean "great job"? DBA or what?
>>
>> "Susan Cooper" <SusanCooper@.discussions.microsoft.com> wrote in message
>> news:53057DE9-77E0-4E6F-BF5D-E450B6544990@.microsoft.com...
>> > Hi,
>> >
>> > I've been asked to take a brainbench test before an interview for a
>> > great
>> > job. Does anyone know where I can find some test questions to practice
>> > with?
>> >
>> >
>> > Thanks a bunch.
>> > Susan
>>|||thanks!
"Uri Dimant" wrote:
> Here you go
> http://vyaskn.tripod.com/iq.htm
> Good luck
>
> "Susan Cooper" <SusanCooper@.discussions.microsoft.com> wrote in message
> news:B466C086-EF06-4E32-B04F-C833072E9CDE@.microsoft.com...
> > Sorry... great job means a senior DBA with a government agency.
> >
> > "Uri Dimant" wrote:
> >
> >> Susan
> >> What does mean "great job"? DBA or what?
> >>
> >>
> >> "Susan Cooper" <SusanCooper@.discussions.microsoft.com> wrote in message
> >> news:53057DE9-77E0-4E6F-BF5D-E450B6544990@.microsoft.com...
> >> > Hi,
> >> >
> >> > I've been asked to take a brainbench test before an interview for a
> >> > great
> >> > job. Does anyone know where I can find some test questions to practice
> >> > with?
> >> >
> >> >
> >> > Thanks a bunch.
> >> > Susan
> >>
> >>
> >>
>
>