1

Being a newbie to database migration, can I script all the database jobs one by one and run them against a new server to create these jobs?

If not, why do we use these SQL job scripts?

Thanks in advance.

user3502587
  • 11
  • 1

1 Answers1

3

can I script all the database jobs one by one and run them against a new server to create these jobs?

Yes

But anything dependent will need to exist, i.e. users, proxies, if there is a path in the task it needs to work against the new server.

Normally there is some kind of migration process, i.e. "I'll need to change all D drives to E, I'll need to change the proxy name" etc.

Why don't you try one and see.

Nick.Mc
  • 391
  • 3
  • 15