Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Scheduler in 7703 Data Migrator
Go
New
Search
Notify
Tools
Reply
  
Scheduler in 7703 Data Migrator
 Login/Join
 
Gold member
posted
Hi,

I schedule my flow for every 1 minute on all days (Sunday to Saturday). Please find the below screenshot of my scheduler properties

Problem is: Scheduler is not running for every 1 minute.

Can anyone tell anything i need to change in the properties?

Please help!

Thanks
Madhu
 
Posts: 51 | Registered: September 30, 2008Reply With QuoteReport This Post
Member
posted Hide Post
Can you repost the scheduler properties?

How long does the flow run take to complete?


iSM 616
iDM 7705
iDQC 802
WF 77
Windows 2008 Server
 
Posts: 29 | Registered: May 01, 2007Reply With QuoteReport This Post
Gold member
posted Hide Post
I set the properties as like the below one

General
Schedule Status Active
Schedule Type Recurring
Interval Type Minutes
Interval Value 1
Log Destinations ETLLOG, E-Mail

Start and stop range
Start Date 11/01/2011
Start Time 10:05
Specify End Date

Special date/time ranges
Days of the Week Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday
Days of the Month 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31
Last Day of the Month
Intraday Start 00:01
Intraday End 23:59
Run on Holidays
 
Posts: 51 | Registered: September 30, 2008Reply With QuoteReport This Post
Guru
posted Hide Post
How often is the scheduler itself running?

In Workspace > Special Services and Listeners > SCHEDULE > Properties: check the value of sched_interval (in seconds) is set to 60.

Or in edaprint look for the line:

DM: interval : 60

There you can also confirm that the scheduler is indeed running.
 
Posts: 376 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
Gold member
posted Hide Post
quote:
Originally posted by Madhumitha:
Clif,

For some flows I will change the current system date

For Example, If in Scheduler Agents > Next Run Time column - 2012/01/26 10:27, If I change the system date to 2012/01/24 the scheduler is not working without restart the ETL Server.

Please suggest me how I can solve this problem without restart the ETL server.

Thanks
Madhu
 
Posts: 51 | Registered: September 30, 2008Reply With QuoteReport This Post
Guru
posted Hide Post
I'm sorry the scheduler doesn't handle time turning backwards. However have you tried restarting just the scheduler instead of the entire server?
 
Posts: 376 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
Gold member
posted Hide Post
How we dynamically restart the scheduler?
 
Posts: 51 | Registered: September 30, 2008Reply With QuoteReport This Post
Guru
posted Hide Post
In Workspace > Special Services and Listeners > SCHEDULE - Right click and select Stop, then Start.
 
Posts: 376 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
Gold member
posted Hide Post
Clif,

Is there any other possible to restart the scheduler with the help of store procedure(by using any code). Because we no need to do this manually. Is any other way to do? Please help me

Thanks
Madhu
 
Posts: 51 | Registered: September 30, 2008Reply With QuoteReport This Post
Guru
posted Hide Post
Form ...Server, Diagnostic Functions, Command Window for Manual Operations:

edastart {-stopsched | -startsched}
 
Posts: 376 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
Gold member
posted Hide Post
Clif,

I run this code "D:\ibi\srv77\dm\bin\edastart -startsched" in command prompt its works fine and i got the below message
"Requesting to start CM
"'start CM' request processed by Workspace Manager"

when i use same code in iway datamigrator store procedure "-DOS D:\ibi\srv77\dm\bin\edastart -startsched" and run it but i am the below error
"Requesting to start CM
"'start CM' request to Workspace Manager failed - Unknown"

What i have to do? Please help i need to complete this.

This message has been edited. Last edited by: Madhumitha,
 
Posts: 51 | Registered: September 30, 2008Reply With QuoteReport This Post
Gold member
posted Hide Post
I run the code "D:\ibi\srv77\dm\bin\edastart -startsched" in command prompt its works fine and i got the below message
"Requesting to start CM
"'start CM' request processed by Workspace Manager"

when i use same code in iway datamigrator store procedure "-DOS D:\ibi\srv77\dm\bin\edastart -startsched" and run it but i am getting below error
"Requesting to start CM
"'start CM' request to Workspace Manager failed - Unknown"

Can any one Please help me how to processed
 
Posts: 51 | Registered: September 30, 2008Reply With QuoteReport This Post
Silver Member
posted Hide Post
Hello Madhumitha,
Please open a hottrack case and we'll investigate.
It would be useful to run the procedure with the traces ON, and to collect the saved diagnostics.
Also, could you please describe (in the case) what are you trying to achieve? We might find a good solution if we'll learn the details of your task.
Thanks.
 
Posts: 32 | Registered: February 13, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Scheduler in 7703 Data Migrator

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.