Problem Creating Job and Running The JOb

Hello All,
I am having problem with my SQL Server 2000. I don't know this
is best place to put this question but i don't have any other way. I have sql
server with service pack 4 installed on it. I create a simple DTS package and
then Try to schedule it which will automatically create a Job. When i try to
run this job. It failed with the following error.
"The system cannot find the file specified"
Please any help .......................
Does the job work when you run it manually?
Do you run it on your computer or the server when run manually.
Is it using any files that reside on the hard drive?
Nik Marshall-Blank MCSD/MCDBA
Linz, Austria
"Faisal Mirza" <Faisal Mirza@.discussions.microsoft.com> wrote in message
news:C2CCB594-B819-4E2C-BED3-4514D54AD102@.microsoft.com...
> Hello All,
> I am having problem with my SQL Server 2000. I don't know
> this
> is best place to put this question but i don't have any other way. I have
> sql
> server with service pack 4 installed on it. I create a simple DTS package
> and
> then Try to schedule it which will automatically create a Job. When i try
> to
> run this job. It failed with the following error.
> "The system cannot find the file specified"
> Please any help .......................
|||Hi,
Thanks for quick reply. I run it manually and it fail. With the same
error. The dts is simple select statement. And i run it. it works fine.
Another information which i think is usefull:
When i try to run DTSRUN command from command prompt it will say Unknown
command. Which means it is the problem of installation.
I run the Installation file again and fix the registry but the problem is
still there.
I run again the service pack 4 but not help full
Thanks in advance......
"Nik Marshall-Blank" wrote:

> Does the job work when you run it manually?
> Do you run it on your computer or the server when run manually.
> Is it using any files that reside on the hard drive?
> --
> Nik Marshall-Blank MCSD/MCDBA
> Linz, Austria
> "Faisal Mirza" <Faisal Mirza@.discussions.microsoft.com> wrote in message
> news:C2CCB594-B819-4E2C-BED3-4514D54AD102@.microsoft.com...
>
>
|||If the installation is corrupted then applying SP4 will not fix it. You may
have to ununstall and re-install. If you do this take a backup of your user
databases or detach them first and copy them to another folder. You can copy
them back and restore/attach after re-installing.
Nik Marshall-Blank MCSD/MCDBA
Linz, Austria
"Faisal Mirza" <FaisalMirza@.discussions.microsoft.com> wrote in message
news:18C9C988-5F88-4C58-900D-3E69C4E7104A@.microsoft.com...[vbcol=seagreen]
> Hi,
> Thanks for quick reply. I run it manually and it fail. With the same
> error. The dts is simple select statement. And i run it. it works fine.
> Another information which i think is usefull:
> When i try to run DTSRUN command from command prompt it will say Unknown
> command. Which means it is the problem of installation.
> I run the Installation file again and fix the registry but the problem is
> still there.
> I run again the service pack 4 but not help full
> Thanks in advance......
> "Nik Marshall-Blank" wrote:
|||Hi Faisal,
Do sql Agent is runing.
Is sql agent running under local system user account
Can u manually create a job.
HTH
from
Doller
Faisal Mirza wrote:[vbcol=seagreen]
> Hi,
> Thanks for quick reply. I run it manually and it fail. With the same
> error. The dts is simple select statement. And i run it. it works fine.
> Another information which i think is usefull:
> When i try to run DTSRUN command from command prompt it will say Unknown
> command. Which means it is the problem of installation.
> I run the Installation file again and fix the registry but the problem is
> still there.
> I run again the service pack 4 but not help full
> Thanks in advance......
> "Nik Marshall-Blank" wrote: