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
Scheduler failing to run job with SQL server as source
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3
- Joined: Thu Oct 10, 2013 11:28 am
-
- Participant
- Posts: 3
- Joined: Thu Oct 10, 2013 11:28 am
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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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).
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).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 3
- Joined: Thu Oct 10, 2013 11:28 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?
Can you enter DataStage using the admin user-id and try running your job?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: