Import/Export SQL jobs to different system in SQL 2005

http://www.sqlservercentral.com/Forums/Topic634107-146-1.aspx

i am not registered on sqlservercentral.com so please tell me something else. thanks

Hi tech2010,

Have a look at the following:
http://blog.sqlauthority.com/2007/08/21/sql-server-2005-create-script-to-copy-database-schema-and-all-the-objects-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/

Good Luck!

Gary

by looking this article. I am not sure that if that should be the case for system database. Becuase all it tell you that we can create a script for any database which brings schema and everything. But i am scared to do this way. All i want to do is to pull over my SQL jobs from one physical SQL 2005 box to other physicall SQL 2005?

How about backup & restore?

I am sorry there is no such option still available.

>>How about backup & restore?<<

are you sure backup will take backup of SQL Agent job as well? ;)

See if this helps
http://support.microsoft.com/kb/314546

the link you provided says the same as my link ;) generate the script and move it. not direct export like we used to do for table.

is it ok if i right click on each job and generate a script and then run that script on the new server?