i am managing 2 servers. 1 hot 1 standby and i need a way to script
only certain jobs off the hot server to the standby server. i have
seen many scripts out there to do all jobs but i need to only to do a
couple not all.

-dave

There's a dts package step that will move the jobs. You can schedule that
to run nightly and it'll update any changes to the jobs.

--
Denny Cherry
DBA
GameSpy Industries
"david gladstone" <david (AT) automatedfinancial (DOT) com> wrote

You can use SQLDMO to script only the jobs you want and reapply them on the
destination server if you are using SQL Server 7 but in 2000 there is the
transfer jobs task

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"david gladstone" <david (AT) automatedfinancial (DOT) com> wrote