General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only