Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Scripting Jobs

Status
Not open for further replies.
vaidyanathanpc

vaidyanathanpc

Programmer
Nov 30, 2001
36
0
0
IN
Hi,
I have about ten jobs running under SQL Server agent on my server. I want to create a script file of three of the jobs to restore on to a different server. I selected all the three jobs -> right click -> generate SQL script. In the script generated, there was only one job scripted. The script was not created for all the three jobs but for only one job. Do I have to generate a script file for each job that I have on my server? Can I not generate a single script file for all the three jobs?

Thanks
P.C. Vaidyanathan
 
Status
Not open for further replies.

Similar threads

scevbact
  • Locked
  • Question
SQL scripting 1
Replies
4
Views
40
gbaughma
gbaughma
junkmail
  • Locked
  • Question
programmatically add jobs to an existing schedule
Replies
2
Views
23
junkmail
junkmail
junkmail
  • Locked
  • Question
scheduling jobs
Replies
2
Views
17
junkmail
junkmail
jshurst
  • Locked
  • Question
Scripting out Stored Procs
Replies
2
Views
9
markros
markros
codrutza
  • Locked
  • Question
ech month jobs sales
Replies
0
Views
9
codrutza
codrutza

Part and Inventory Search

Sponsor

Back
Top