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:O7gGcu00DHA.4064@.tk2msftngp13.phx.gbl...
> 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.
>
>
>

No comments:

Post a Comment