Wednesday, March 21, 2012

Job not working in SQL server

Hi,
I have put a job with 3 steps.
But appear this message : "The job failed. The Job was
invoked by Schedule 15 (IMPORT_DBF_TO_SQL). The last step
to run was step 3 (IMPORT_DBF_TO_SQL)".
What I Can do to solve this problem'
ThanksYou need to see what Step 3 :- IMPORT_DBF_TO_SQL is trying to do.
I would imagine it executes a DTS Package, hopefully that DTS package was
designed to produce a Log output file. That Log file will give you the real
reason for the failure.
--
HTH
Ryan Waight, MCDBA, MCSE
"Joao Sousa" <msousa@.pinheirosaltos.pt> wrote in message
news:0a4001c3b4d7$da8407c0$a301280a@.phx.gbl...
> Hi,
> I have put a job with 3 steps.
> But appear this message : "The job failed. The Job was
> invoked by Schedule 15 (IMPORT_DBF_TO_SQL). The last step
> to run was step 3 (IMPORT_DBF_TO_SQL)".
> What I Can do to solve this problem'
> Thanks
>|||Hi,
But its very strange, because i have in another SQL server
the same job and it's ok!!
the steps are:
1- DeleteCurrentData -- Transact-SQL Script
2- Convert DAT to DBF -- Transact-SQL Script
3- IMPORT_DBF_TO_SQL -- Operating System Command
>--Original Message--
>You need to see what Step 3 :- IMPORT_DBF_TO_SQL is
trying to do.
>I would imagine it executes a DTS Package, hopefully that
DTS package was
>designed to produce a Log output file. That Log file will
give you the real
>reason for the failure.
>--
>HTH
>Ryan Waight, MCDBA, MCSE
>"Joao Sousa" <msousa@.pinheirosaltos.pt> wrote in message
>news:0a4001c3b4d7$da8407c0$a301280a@.phx.gbl...
>> Hi,
>> I have put a job with 3 steps.
>> But appear this message : "The job failed. The Job was
>> invoked by Schedule 15 (IMPORT_DBF_TO_SQL). The last
step
>> to run was step 3 (IMPORT_DBF_TO_SQL)".
>> What I Can do to solve this problem'
>> Thanks
>>
>
>.
>|||It is impossible for us to know why it fails when all you tell us is that it fails.
Specify an output file for that jobstep and look at the messages in there. Hopefully this program
produces output from which you can determine what it wrong.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Joao Sousa" <msousa@.pinheirosaltos.pt> wrote in message
news:084901c3b4df$9edff550$a501280a@.phx.gbl...
> Hi,
> But its very strange, because i have in another SQL server
> the same job and it's ok!!
> the steps are:
> 1- DeleteCurrentData -- Transact-SQL Script
> 2- Convert DAT to DBF -- Transact-SQL Script
> 3- IMPORT_DBF_TO_SQL -- Operating System Command
>
>
> >--Original Message--
> >You need to see what Step 3 :- IMPORT_DBF_TO_SQL is
> trying to do.
> >
> >I would imagine it executes a DTS Package, hopefully that
> DTS package was
> >designed to produce a Log output file. That Log file will
> give you the real
> >reason for the failure.
> >
> >--
> >HTH
> >Ryan Waight, MCDBA, MCSE
> >
> >"Joao Sousa" <msousa@.pinheirosaltos.pt> wrote in message
> >news:0a4001c3b4d7$da8407c0$a301280a@.phx.gbl...
> >> Hi,
> >>
> >> I have put a job with 3 steps.
> >> But appear this message : "The job failed. The Job was
> >> invoked by Schedule 15 (IMPORT_DBF_TO_SQL). The last
> step
> >> to run was step 3 (IMPORT_DBF_TO_SQL)".
> >>
> >> What I Can do to solve this problem'
> >>
> >> Thanks
> >>
> >>
> >
> >
> >.
> >|||In the output file the message that appear are
"SQL Server Scheduled Job 'import-DBF_to_SQL'
(0x3CB9A4AA25D87B408BF4C3272F2F4C8B) - Status: Failed -
Invoked on: 2003-11-27 04:00:00 - Message: The job
failed. The Job was invoked by Schedule 15
(IMPORT_DBF_TO_SQL). The last step to run was step 3
(IMPORT_DBF_TO_SQL). "
>--Original Message--
>It is impossible for us to know why it fails when all you
tell us is that it fails.
>Specify an output file for that jobstep and look at the
messages in there. Hopefully this program
>produces output from which you can determine what it
wrong.
>--
>Tibor Karaszi, SQL Server MVP
>Archive at: http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"Joao Sousa" <msousa@.pinheirosaltos.pt> wrote in message
>news:084901c3b4df$9edff550$a501280a@.phx.gbl...
>> Hi,
>> But its very strange, because i have in another SQL
server
>> the same job and it's ok!!
>> the steps are:
>> 1- DeleteCurrentData -- Transact-SQL Script
>> 2- Convert DAT to DBF -- Transact-SQL Script
>> 3- IMPORT_DBF_TO_SQL -- Operating System Command
>>
>>
>> >--Original Message--
>> >You need to see what Step 3 :- IMPORT_DBF_TO_SQL is
>> trying to do.
>> >
>> >I would imagine it executes a DTS Package, hopefully
that
>> DTS package was
>> >designed to produce a Log output file. That Log file
will
>> give you the real
>> >reason for the failure.
>> >
>> >--
>> >HTH
>> >Ryan Waight, MCDBA, MCSE
>> >
>> >"Joao Sousa" <msousa@.pinheirosaltos.pt> wrote in
message
>> >news:0a4001c3b4d7$da8407c0$a301280a@.phx.gbl...
>> >> Hi,
>> >>
>> >> I have put a job with 3 steps.
>> >> But appear this message : "The job failed. The Job
was
>> >> invoked by Schedule 15 (IMPORT_DBF_TO_SQL). The last
>> step
>> >> to run was step 3 (IMPORT_DBF_TO_SQL)".
>> >>
>> >> What I Can do to solve this problem'
>> >>
>> >> Thanks
>> >>
>> >>
>> >
>> >
>> >.
>> >
>
>.
>|||That is not the output file. In the job *step*, right tab, you have an option to specify an output
file for the jobstep. This is where all the messages from the command are written. After executing
the job, check this file.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Joao Sousa" <msousa@.pinheirosaltos.pt> wrote in message
news:0a2d01c3b4fb$b7513790$a501280a@.phx.gbl...
> In the output file the message that appear are
> "SQL Server Scheduled Job 'import-DBF_to_SQL'
> (0x3CB9A4AA25D87B408BF4C3272F2F4C8B) - Status: Failed -
> Invoked on: 2003-11-27 04:00:00 - Message: The job
> failed. The Job was invoked by Schedule 15
> (IMPORT_DBF_TO_SQL). The last step to run was step 3
> (IMPORT_DBF_TO_SQL). "
>
> >--Original Message--
> >It is impossible for us to know why it fails when all you
> tell us is that it fails.
> >Specify an output file for that jobstep and look at the
> messages in there. Hopefully this program
> >produces output from which you can determine what it
> wrong.
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >Archive at: http://groups.google.com/groups?
> oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> >"Joao Sousa" <msousa@.pinheirosaltos.pt> wrote in message
> >news:084901c3b4df$9edff550$a501280a@.phx.gbl...
> >> Hi,
> >>
> >> But its very strange, because i have in another SQL
> server
> >> the same job and it's ok!!
> >> the steps are:
> >> 1- DeleteCurrentData -- Transact-SQL Script
> >> 2- Convert DAT to DBF -- Transact-SQL Script
> >> 3- IMPORT_DBF_TO_SQL -- Operating System Command
> >>
> >>
> >>
> >>
> >> >--Original Message--
> >> >You need to see what Step 3 :- IMPORT_DBF_TO_SQL is
> >> trying to do.
> >> >
> >> >I would imagine it executes a DTS Package, hopefully
> that
> >> DTS package was
> >> >designed to produce a Log output file. That Log file
> will
> >> give you the real
> >> >reason for the failure.
> >> >
> >> >--
> >> >HTH
> >> >Ryan Waight, MCDBA, MCSE
> >> >
> >> >"Joao Sousa" <msousa@.pinheirosaltos.pt> wrote in
> message
> >> >news:0a4001c3b4d7$da8407c0$a301280a@.phx.gbl...
> >> >> Hi,
> >> >>
> >> >> I have put a job with 3 steps.
> >> >> But appear this message : "The job failed. The Job
> was
> >> >> invoked by Schedule 15 (IMPORT_DBF_TO_SQL). The last
> >> step
> >> >> to run was step 3 (IMPORT_DBF_TO_SQL)".
> >> >>
> >> >> What I Can do to solve this problem'
> >> >>
> >> >> Thanks
> >> >>
> >> >>
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >

No comments:

Post a Comment