DS.SCHED: Job Scheduled but not started.

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

DS.SCHED: Job Scheduled but not started.

Post by kumar_s »

Hi DSXians,

JobSequence is scheduled from datastage scheduler. It used to run daily. The first entry in the log usually be

DS.SCHED: Started at: 22:30:02 21 SEP 2006, directory <Project>
JobNumber=81, TraceLevel=0/50, JobInstance=2


But last night, this is the only entry available and the job was not executed. So the job was been executed manually in morning. Other jobs which were scheduled, ran ok.

I could see, Craig mentioning the same issue, some years back. Is there any fix for this.

Thanks in Advance.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

On unix it's just a cron tab entry, so if cron is active it should have started the job. Any chance the Sequence did something like a checkpoint restart and did nothing?
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Thanks Kenneth,
I was wondering for the same reason. There is a log in DataStage, which assures that the Cron has executed the job, but job didnt have any further log. Other that that single entry. And started as expected from next day of the schedule.
Even for check point restart, atlest the environment variable settings, Job Start/Stop log should be available.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

If cron fails then you should get an email saying what happened.
Mamu Kim
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Thank Kim.
I dont guess, Cron has failed. Because, there is a single log entry at the scheduled time.
This is very similar to this issue stated by Craig in this post.
http://dsxchange.com/viewtopic.php?t=85 ... c92ba1961b

The topic name is "DS Job Schedual" (I dont this the link will work even if I add www to it)
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Nice to see Craig back from Vaccation. Let me wait, if he has some updates on this.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Unfortunately, no. It was an issue I'd seen in the past but haven't had it reoccur in quite some time. When I reported it to Ascential support way back when, they were as baffled as I was. As noted in the other linked thread (which does work, btw, if you add 'www' to it) it went away all on its own without us doing or changing anything. Very frustrating.

About all I could suggest at this point would be to report it to Support and see if they've gotten any clues about it in the intervening years.
-craig

"You can never have too many knives" -- Logan Nine Fingers
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

:cry: Support :cry:
Btw, even I add www, it asks me for userid and password :x .
Atleast it works for others.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Yah, Support. Sorry. :wink:

The whole link-wants-me-to-log-in thing seems to be about the 'www' part of the URL. If you connect to the site using 'dsxchange.com' then it seems that links will only work for you if they don't contain the 'www.' part. If, like most people I believe, you connect to 'www.dsxchange.com' then any links without the leading 3 dubs won't work for you.

I've found it simplest in that case to right-click on the link to 'copy shortcut' to the clipboard and then paste it into your address bar. After that, you can tweak it so that it works for you before making it go. Or you can take note of the Topic number and tweak your current location's URL to go there...
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply