Hi Lynn,
So here is the good news.
I could create a Sp which executes the Job and also wait untill the job is run success. I have executes this proc in Sql Server DB and it is working awesome.
I am now trying to execute this SP from Ms access VBA code connection thru ADO.
When I excute this SP, its showing an error Query Timeout.
I havent seen this before.
In real my Job takes 3-4 mins to run.
Any ideas how to over come this problem.
I have also tried change the setting in Access Options/Advanced ==> OLE\DDE time out to 240Secs from default 60 sec.
Am stuck at this last step, please get through me with this.
Thanks.
Srini