topic Re: How to deploy and schedule SAS dataflux jobs in SAS Data Management

How to deploy and schedule SAS dataflux jobs

maheshtalla — Tue, 04 Feb 2014 07:06:19 GMT

Hi,

We are working on SAS DataFlux and we have Data Management Studio and Server but no web studio server. We have created one sample job in data management studio and we exported this job to server and tested which is working. Now we need to schedule this job to run in batch process. Can some one please help how to schedule job in dataflux tool or if we can schedule in OS based then what is procedure and how.

Thanks in advance.

Regards

Maheswara Talla.

9980014060

Re: How to deploy and schedule SAS dataflux jobs

skillman — Tue, 04 Feb 2014 14:16:32 GMT

Maheswara,

This question just appeared in another discussion.There is not a job scheduler that ships with DM Studio or DM Server. I use the default scheduler for Windows or CRON for UNIX. The executable is located here (for my install):

C:\Program Files (x86)\DataFlux\DMStudio\studio1\bin>

The command you should execute is dmpexec which takes the following arguments:

usage: dmpexec [options]

options:

-c <file> read configuration from <file>

-j <file> execute job in <file>

-l <file> write log to <file>

-i <key>=<value> set input <key> to <value>

-o <key>=<value> set option <key> to <value>

-b <key>=<value> set job option <key> to <value>

-a authenticate using Authentication Server

Your scheduler should reference a script which resembles this:

"C:\Program Files (x86)\DataFlux\DMStudio\studio1\bin\dmpexec.cmd" -j "DM_JOB_NAME.djf" -l "LOG_FILE.log"

-shawn

Re: How to deploy and schedule SAS dataflux jobs

DaveR_SAS — Tue, 04 Feb 2014 14:40:47 GMT

The DM Studio 2.5 user guide covers the basics of using the dmexec command, which can be used in a scheduler: Running Jobs from the Command Line

Re: How to deploy and schedule SAS dataflux jobs

maheshtalla — Wed, 05 Feb 2014 09:22:28 GMT

Hi Skillman,

Thanks a lot for your reply. It was very much helpful. Is there any other way or by using tools we can achieve this apart from OS based. Please let me know.

Re: How to deploy and schedule SAS dataflux jobs

skillman — Wed, 05 Feb 2014 13:28:48 GMT

If you have a SAS server environment, in addition to Data Management, you may have a scheduler which can schedule jobs from within SAS Management Console.

Re: How to deploy and schedule SAS dataflux jobs

sne7189 — Tue, 18 Nov 2014 07:26:22 GMT

Hi,

Is there any pdf or sas book to reference for sas dataflux data management studio for a beginner as to how to create jobs,various options available in it etc.

Thanks in advance

Regards,

Snehal Rao

Re: How to deploy and schedule SAS dataflux jobs

DaveR_SAS — Tue, 18 Nov 2014 17:23:16 GMT

Snehal, this chapter form the DM Studio user guide covers the basics about creating data jobs:

Maintaining Data Jobs

Re: How to deploy and schedule SAS dataflux jobs

sne7189 — Wed, 19 Nov 2014 06:53:48 GMT

hi im gettin an error when i schedule a sas program by creating a batch file through windows task scheduler.

Re: How to deploy and schedule SAS dataflux jobs

sne7189 — Wed, 19 Nov 2014 06:54:27 GMT

hi im gettin an error when i schedule a sas program by creating a batch file through windows task scheduler.