Data services Job execution

[mohan_salla]

Hi there,

I have executed a job, The Job monitor is showing as 'Ready' state and didn't change the state to PROCEED even after 30mins. Not sure what's going on. I ran the same job about 2 hours ago, it went through correctly and data transmitted.

The source table is having more than a million rows.

Could you please help me out.

Thanks

Mohan

[Former Member]

I don't know why, but we had one hung up for days. After restarting the Server Intelligence Agent the job completed normally.

To do that, use the Central Configuration Manager on the server (not the Central Management Console web page).

Regards,

Sean

[mohan_salla]

Hi Sean,

Thank you very much for your reply.

This was due to locking the source database table in MYSQL server. I have requested my DBA to unlock it, after that job was run successfully.

Cheers