Scheduler failing to run job with SQL server as source

baviriajay · Post by **baviriajay** » Thu Oct 10, 2013 11:40 am

Hello ,

My job has SQL server Enterprise stage to connect to SQL server DB.
It runs fine if I run it manually either from designer or director but the job is failing when it is scheduled.
Please help me out.

Thanks in Advance,
Ajay

lstsaur · Post by **lstsaur** » Thu Oct 10, 2013 11:54 am

What's Windows OS? What's error message?

baviriajay · Post by **baviriajay** » Thu Oct 10, 2013 1:06 pm

I am using windows OS. and working on 8X version.
And it is faling with below error,

main_program: Fatal Error: Could not connect to datasource?? (-1; Dbuser; Dbname; [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'ITSERVICES\MOKSCY3CDRDLA12$'.)
:
Resource bundle corresponding to message key return code {0} from SQLConnect(handle, {1}, ****, {2}) with message {3} not found! Check that DSHOME or APT_RESPATH is set.

but I was able to run the job with the same credentials and it is running successfully but its failing while it is scheduled.

Thanks In Advance

ray.wurlod · Post by **ray.wurlod** » Thu Oct 10, 2013 3:08 pm

How are you scheduling the job?
When it runs from the scheduler, check the job log to verify that the credentials have been passed correctly (I am assuming that they are job parameters).

baviriajay · Post by **baviriajay** » Thu Oct 10, 2013 3:59 pm

I am scheduling my job from DS director.
The job failed while passing parameters so I tried hard-coding it still it fails while it is scheduled.

ray.wurlod · Post by **ray.wurlod** » Thu Oct 10, 2013 7:01 pm

Does the log show the credentials that were actually passed when connection was attempted?

ArndW · Post by **ArndW** » Fri Oct 11, 2013 1:24 am

The difference between running it from your designer/director and from the scheduler is the user-id used for the DataStage login, and somehow this difference is affecting your SQL-Server login.

Can you enter DataStage using the admin user-id and try running your job?

ray.wurlod · Post by **ray.wurlod** » Fri Oct 11, 2013 4:42 am

Also visit the Project Properties in DataStage Administrator. You may find (on the Schedule tab) that a different user has been set up to run scheduled jobs.