Friday, March 30, 2012

How to Trigger a Job on MSDE from SQL Server

Hi,
Can i have "Jobs" on MSDE .
If yes, then i want that jobs to be fired from SQL Server.
Actually what i want is to have one SQL Server, and MSDE on all other
machines. And the central SQL Server would take care of when a perticual job
is to be exicuted.
Can i do this. Will "Linked Servers" help.
Regards,
Raj Dhrolia.Please don't post independently to multiple groups. See my reply in
microsoft.public.sqlserver.tools
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Raj Dhrolia" <rajdhrolia@.hotmail.com> wrote in message
news:%23YIWPu00DHA.2568@.TK2MSFTNGP09.phx.gbl...
quote:

> Hi,
> Can i have "Jobs" on MSDE .
> If yes, then i want that jobs to be fired from SQL Server.
> Actually what i want is to have one SQL Server, and MSDE on all other
> machines. And the central SQL Server would take care of when a perticual

job
quote:

> is to be exicuted.
> Can i do this. Will "Linked Servers" help.
> Regards,
> Raj Dhrolia.
>
>
>

No comments:

Post a Comment