Focal Point
Scheduler in 7703 Data Migrator

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/9087063916

April 24, 2012, 05:06 AM
Madhumitha
Scheduler in 7703 Data Migrator
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
April 24, 2012, 12:45 PM
AK
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
April 25, 2012, 04:40 AM
Madhumitha
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
April 25, 2012, 11:49 AM
Clif
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.
April 27, 2012, 06:47 AM
Madhumitha
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

April 30, 2012, 09:53 AM
Clif
I'm sorry the scheduler doesn't handle time turning backwards. However have you tried restarting just the scheduler instead of the entire server?
May 02, 2012, 06:40 AM
Madhumitha
How we dynamically restart the scheduler?
May 03, 2012, 09:55 AM
Clif
In Workspace > Special Services and Listeners > SCHEDULE - Right click and select Stop, then Start.
May 04, 2012, 04:37 AM
Madhumitha
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
May 07, 2012, 10:17 AM
Clif
Form ...Server, Diagnostic Functions, Command Window for Manual Operations:

edastart {-stopsched | -startsched}
May 08, 2012, 03:06 AM
Madhumitha
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,
May 10, 2012, 03:20 AM
Madhumitha
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
May 11, 2012, 10:22 AM
Marina
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.