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
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
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
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.
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.
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
Snehal, this chapter form the DM Studio user guide covers the basics about creating data jobs:
hi im gettin an error when i schedule a sas program by creating a batch file through windows task scheduler.
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
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.