Execute Command Stage in Sequencer Job

jpnrd · Post by **jpnrd** » Tue Jul 06, 2010 12:04 pm

Hi,

I Unloaded the max of timestamp in to a text file using sequential stage. I need to pass this as job parameter to next job using sequencer job. For this I used Execute command stage and in the command line I tried 'Cat Textfilepath.txt'. In the next job activity I specified job parameter values as Execute Command Return Value. But the job is getting aborted every time.

the warning it is showing is

SequencerTest1..JobControl (@Job_Activity_3): Controller problem: Error calling DSRunJob(Px_Etl_Unld_Pc_PolicyPeriod_TodaysDate1), code=-2
[Job is not in the right state (compiled and not running)]

I tried using 'Field Textfilepath.txt' now the second job is getting aborted.

Am I doing it in correct way. If not please correct me. I am new to this sequence jobs so please help me.

anbu · Post by **anbu** » Tue Jul 06, 2010 12:29 pm

Above error message means that job was already running when the Sequence tried to run it.

jpnrd · Post by **jpnrd** » Tue Jul 06, 2010 12:34 pm

Yes, you are right. I am sorry for posting that warning. The problem is job is getting aborted.

chulett · Post by **chulett** » Tue Jul 06, 2010 12:44 pm

You'd have to post your abort message and be specific about which job is aborting if you wanted anyone to be able to help.

jpnrd · Post by **jpnrd** » Tue Jul 06, 2010 12:49 pm

The Second job to which I am passing timestamp is getting aborted. The abort message I am getting in sequence job is

SequencerTest1..JobControl (DSWaitForJob): Job Px_Etl_Unld_Pc_PolicyPeriod_TodaysDate1 has finished, status = 3 (Aborted)

jpnrd · Post by **jpnrd** » Tue Jul 06, 2010 12:53 pm

I went to the Job Log and Job log is saying this error messge

SQLServer_Enterprise_0,0: [IBM (DataDirect OEM)][ODBC SQL Server Driver][SQL Server]Conversion failed when converting datetime from character string.

jpnrd · Post by **jpnrd** » Tue Jul 06, 2010 12:57 pm

Yes, I just posted it above. I want to know is my approach to get the timestamp value to a variable correct or not?

anbu · Post by **anbu** » Tue Jul 06, 2010 12:59 pm

This is probably due to an invalid timestamp format. What is your timestamp format?

jpnrd · Post by **jpnrd** » Tue Jul 06, 2010 1:01 pm

2010-05-26 03:34:44.450

chulett · Post by **chulett** » Tue Jul 06, 2010 1:04 pm

It is *a* correct approach, yes. However, it seems your second job doesn't like the timestamp format you've passed in.

jpnrd · Post by **jpnrd** » Tue Jul 06, 2010 1:10 pm

But when I hardCode the same timestamp Value in Sql Sever Stage Its working fine why is that happening?

anbu · Post by **anbu** » Tue Jul 06, 2010 1:16 pm

I think i faced same issue before. If you are using cat Textfilepath.txt, you will get a newline char along with timestamp.

Try this

Code: Select all

printf $(<Textfilepath.txt)

jpnrd · Post by **jpnrd** » Tue Jul 06, 2010 1:27 pm

I tried Printf Still the same problem exists. Any other suggestions Please

anbu · Post by **anbu** » Tue Jul 06, 2010 1:42 pm

Check the director log and find what timestamp value is passed to the job?

What is the data type of timestamp parameter used in job Px_Etl_Unld_Pc_PolicyPeriod_TodaysDate1?

anbu · Post by **anbu** » Tue Jul 06, 2010 1:51 pm

I missed quotes in the above command. Without quotes you will get only date and not the timestamp part. Try with quotes as here

Code: Select all

printf "$(<Textfilepath.txt)"