Warning Message - Job must be reset before it can run.

ketfos · Post by **ketfos** » Thu Feb 08, 2007 11:52 am

Hi,

I have a job scheduled to run at 9.00 am in the morning.
I got this warning message in the error log

Job IClaimsPolicyKeyUpdate must be reset before it can run.

The source reads the target table for policyid is null.
The action is to concatenate policyNumber and POlicyYear and populate it to policyid column, if policyid is null.

After the above warning, it reads the source and updates the table as per above select query correctly.

Why do I get this warning message in job log.

Ketfos

narasimha · Post by **narasimha** » Thu Feb 08, 2007 11:57 am

Did you have an abort in your previous run.
Are you using "Reset if required then run" options in your jobs?

ketfos · Post by **ketfos** » Thu Feb 08, 2007 12:02 pm

Hi,

I checked my job logs for last four days.

The job ran without any warning message.

Where do i look for
"Reset if required then run" options in my jobs?

Ketfos

narasimha · Post by **narasimha** » Thu Feb 08, 2007 12:06 pm

ketfos wrote:Where do i look for
"Reset if required then run" options in my jobs?

Depends on how you are running your jobs

- In the Job Avtivity you have an option "Reset if required then run"
- In the command line you have options to use reset along with dsjob.

Also an exact search on "must be reset before it can run" did reveal similar issues, you can check that out too.