DSXchange

We would like to check in all our DS jobs to CVS. How can I create individual DSX files for all the jobs? -- well, apart from doing it one-by-one in Manager
Thanks in advance..

Thanks, guys.. That's what am also thinkin' - purge regularly.

Sorry, forgot to mention it has to wait max 5 hours. I was able to create the sequence however, the problem i see is that everytime the job that checks the table is called, it creates logs. If I have to loop every min for 5 hours, it will create the log 300x (max). Is that a good design???

I need to create a job that waits for a row with the value of current date to appear before the load can proceed. Say, the table is Load_Schedule and it has only one field called 'Load_date'. My job should wait for 1 hour for the Load_date to have a value equal to sysdate before it proceeds to the n...

Thanks, Ray. Just wondering if anybody knows a good way to name them or has done so - I can't think of anything better than something like: lnk_To_<Job_name/ChildSequence name>

Anyone knows any naming convention for links inside Sequencers??

I am a beginner in BO. Can you suggest a good BO forum? Thanks..

ray.wurlod wrote:Let's begin with a question - how does the routine generate the data in the first place?

I use a For loop to parse all jobs in the Project. Then one by one, I generate a line which has the jobname, starttimestamp and endtimestamp delimited by a space. I use LogMsg to display them to the logs.

Thanks for your reply. That is one option I was actually thinking. It may be difficult for me as a beginner to get the info from routine to database directly - but 'routine to file to db' may be easier. However, how do i do that?? My problem is how to get the info passed from routine to either file ...

I need to list the start and end timestamps of all the jobs under a Project. I am able to do that using a Routine (function) and LogMsg. However, I need to save the info to database. I have a table with the following columns: job_name, start_time, end_time. I am sure this requirement is not new to e...

Hi,

I'd like to learn how to write routines. Do we have any available material in the forum? Or any related link (like tutorials and examples) will also be appreciated.

Thanks.

Hi, I have a requirement wherein given the Main sequencer name, I have to save to database the start and end time of all its child jobs and child sequencers. I dont know how to write a routine as I am a beginner, needless to say, the function which returns the child jobs/sequencers of a main sequenc...

Hi,

What does this error mean:
"DSD.UVOpen rm: cannot remove `chg_or_num/.nfs002d3c0900006bdb': Device or resource busy"
and how do I fix this?

Thanks in advance.

Hi,

I would like to find which jobs/sequencers use (that is read or write) a particular table. Is there a way using Administrator or Manager? If so, please let me know how.

Thanks in advance.

Hi, First and foremost, I have very raw knowledge on DS so please bear with me :) I would like to get the start, end time, elapsed time of a job and save them to a database table which has these 3 info as columns. I know I can use the dsjob or DSGetJobInfo, but I don't have any idea how to write the...