DSXchange

Yes, of course. That would be the nature of sequential media - the records read back only in the order they were written out in.

And?

Ask a question.

Most of which is, in fact, lifted straight from Ken Bland's script posted four or five years ago. Stop passing in userid and password for each run request and instead investigate the use of the -file option.

Looks like you've already answered your question with a 'Yes' which is certainly one answer and probably the 'most proper' one. Technically, you could also send an email from an After Job subroutine, one that checks JOBINTERIMSTATUS and - if it sees the job is going to Abort - sends an email to that...

You need to ensure your Key column(s) are unique, or at least "unique enough" for the task at hand. Don't worry about any "overhead" unless you go crazy with your number or size of keys.

Again, nothing will give you any sort of "logs for all projects". You can, however, loop thru a list of projects and loop thru a list of jobs within a given project and extract (one job at a time) log entries for a specific date range.

Looks like you're gonna need to try again. I suggest you not only include an actual question in the body of your post but that you rephrase it as well as the current subject is... unclear. Are you asking how, in UNIX, to count the number of records in an XML file? (Typical answer: 1) Or how to get a...

Well then, you need to mark your post as Resolved as well.

Well... keep in mind the fact that once a topic rolls off the first page, pretty much the only thing that's going to bring it back to people's attention is a reply, much like you just did. So are you saying that the statements you have in the After SQL tab are not even being executed or they are bei...

Why can't you change them? Are they Read Only jobs or in a Protected project? If so, you can use the Director's "Job/Set Defaults..." option to change their default value.

Well, then it would be great if you could do two things: 1) Post the resolution and 2) Mark the thread as Resolved.

Thanks.

How often are you committing changes?

So now the question is - what does Sybase expect in the way of a Timestamp? The ISO standard YYYY-MM-DD HH24:MI:SS?

That would entirely depend on the nature of the problem being solved.