DSXchange

Craig

If you call this in an after job routine will it know if the job is going to finish with warnings or abort because the other one always shows running?

Why not use JOBNO? This is stored in DS_JOBS. You can easily look it up based on the job name.

Do an exact search for JobAct and kduke as the poster. One of the posts is http://www.dsxchange.com/viewtopic.php? ... ght=JobAct

You may need to extract this info before you run your sequence into a hashed file and look it up at run time.

It happens to me a lot. I thought it was my fault.

There is a link on my tips page on how to install it. A little video. There is really only one job that gets row counts. It does call a couple of routines to clean up timestamps. There are 3 tables you need. The rest of the jobs help report on this metadata and other metadata. There are some jobs wh...

Craig gave the best practices document. It is on my tips page. Thanks Craig.

The AS400 ODBC driver does have the NLS character set defined as well. This could be the issue.

By the way welcome to DSX.

You need my reseed job that is a part of EtlStats.

What about http://www.dsxchange.com/viewtopic.php? ... ight=crc32

It creates a different directory to backup todays data like YYYYMMDD. It can separate server backups because the server name is part of the DSX.

Routines have to be done manually. Shared container for some reason get exported along with the job.

We had a guy on our team named Lee Smith. He automated with a UNIX script dumping all datasets and archiving them and then deleting them. If you dump them then I think you can reimport them some how. I have not researched any of this but I can if this is critical to you.

We use CVS now and it works fine. We fill out migration forms which list all the jobs we want migrated to TEST from DEV. I scripted a solution which I think I posted recently. If you cannot find it then let me know. It is basically using most of DataStageBackup.bat with DsExport.exe to export one jo...

The posts Arnd talks about have \\PURGE.SETTING in them. Do a search. You can do a SQL DELETE to delete the rows without removing your purge settings. It is possible. Maybe not recommended. Ken Bland has a job or routine on his web site to set all the purge settings for every job. Look for that rout...

Windows sometimes loses schedules after rebooting. I always go in and double check after a reboot.