Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Jobs,local packages
Message
From
14/06/2002 12:14:01
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00668297
Message ID:
00668607
Views:
17
>Hi J.Crescencio:
> How do you script a job? When I transfer my tables from one server to another server, I first created the script file containing tables, view and SP I than ran the script file, however while creating my script file, I did not see any option to script my jobs.
>I tried scripting the jobs, by selecting the job/All Tasks/Script All Jobs, but I was not able to create the job on my new server.
>Thanks
>MA

I have not tried to do "Script All Jobs" but scripting individual jobs has worked fine for me. Somewhere on the script you should have calls to msdb.dbo.sp_add_job, and you would need permissions for adding jobs. What version of SQL Server?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform