DSXchange

we have serverjob where we use an ODBC to connect to Sql Server and the job is designed in such a way that it runs a store procedure. we run this job using a perl script .Based on the previous status of the job it will wither Reset and Run the Job or Directly Runs the Job. The Issue with our job is the Store Procedure is Beeing Executed Twice when Ever the Previous Status Of the Job is in aborted status. And I had found that it is beeing executed During the Reset Run and Normal Run

Can Any one Let me know Why the Store Procedure is beeing Executed During the RESET

How exactly is your script doing the "reset"? Post your script or at least that relevant portion.

this is one we are using for the Reset
$ENV{DSTAGE_EXE}/dsjob -run -mode RESET -wait $project_nm $job_nm1`;

For the Run We are using

`$ENV{DSTAGE_EXE}/dsjob -run -mode NORMAL -wait -jobstatus $job_param1 $project_nm $job_nm1`;

While Reset it is Taking the Params from the Previous Run

OK, that all looks fine. So, your ODBC Action is set to "Call stored procedure"? If that actually runs the proc during a reset, I'd report that as a bug to your official support provider.

Before Opening a Ticket i just want to make sure will the Reset/validate of DS Job invoke the Call Statement

You'd need to open a ticket to find out the "official" answer to that question. I don't think it should but then I don't use the ODBC stage.

Reset/validate of DS Job will invoke the Call Statement . inoder to see that the Store pRoc is Not executed you need to pass a variable so that Store Proc Knows whether u are Resting or Running a Normal Run

So that's the official answer, eh? Yuck.

Still seems like a bug to me. [shrug]