"Khor Xiang Yi" <xiangyi@jamminc.com.my> wrote in message
news:082101c37c13$dc882a80$a401280a@phx.gbl...
> Hi experts,
>
> I am using SQL DMO in my program to call a SQL Server
> Agent Job. This SQL Server Agent Job is used to run the
> replication process at the subscriber.
>
> Basically my program will:
> 1. Read the name of the agent job saved in a database
> table.
> 2. Run the above agent job (with the name from 1.) using
> SQL-DMO.
>
> However I am getting an error from SQL-DMO stating that
> it cannot find the agent job with that name from the job
> collection. I have checked and the name is correct.
>
> The really weird thing is, on some machines, I do not
> have this error, while on other machines, I have this
> error.
>
> Does anyone have any idea? Pls kindly advise. TQ in
> advance.

>-----Original Message-----
>can you post a small repro case and maybe you want to
tell me how those
>jobs that cause you problems are named (maybe there is a
problem with some
>specific names, patterns...). I am interested in SQLDMO
code you have not
>anything else.
>
>thank you
>--
>Ovidiu Craciun [MS]
>--//----
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>--//----
>"Khor Xiang Yi" <xiangyi@jamminc.com.my> wrote in message
>news:082101c37c13$dc882a80$a401280a@phx.gbl...
>> Hi experts,
>>
>> I am using SQL DMO in my program to call a SQL Server
>> Agent Job. This SQL Server Agent Job is used to run
the
>> replication process at the subscriber.
>>
>> Basically my program will:
>> 1. Read the name of the agent job saved in a database
>> table.
>> 2. Run the above agent job (with the name from 1.)
using
>> SQL-DMO.
>>
>> However I am getting an error from SQL-DMO stating that
>> it cannot find the agent job with that name from the
job
>> collection. I have checked and the name is correct.
>>
>> The really weird thing is, on some machines, I do not
>> have this error, while on other machines, I have this
>> error.
>>
>> Does anyone have any idea? Pls kindly advise. TQ in
>> advance.
>
>
>.