Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Kannan_JrDBA
Starting Member
4 Posts |
 Posted - 2008-04-25 : 10:24:16
|
| Sir,I am new to this forum. I need a help. I want to transfer all the SQL Agent job to another server. For this i wanted to do thru Stored procedures. Why? Every day my office people will create a new job depends on their businnes. The Same job should be on another server too.Any help wolud be much appriciatedThank you sirkannan kumar |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-25 : 11:24:37
|
| you can do with Transfer Job Task in SSIS. |
 |
|
|
Kannan_JrDBA
Starting Member
4 Posts |
Posted - 2008-04-25 : 11:32:18
|
| Sodeep, Thanks for your reply. I can do thru SSIS. But i should do thru only stored procedures not SSIS. I already did the job with SSIS. But everyday I have to alter my SSIS pacakges. So I need a dynamic process with SP.Thankskannan kumar |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-25 : 11:45:40
|
| Then you have to extract new jobs from Msdb..sysjobs. |
|
|
|
Kannan_JrDBA
Starting Member
4 Posts |
Posted - 2008-04-25 : 11:59:01
|
| Okay!! Can you help me to write a store procedure to extract the job details from Sysobjects..ThanksKannan |
|
|
|
|
|
|
Help Need