realtimer
asked on
How can I automate scripting SQL jobs?
I can right click a SQL job and select "Script job as" and export the job configuration. Is there a way to automate this process for all SQL jobs so it can be run on schedule?
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Scott Pletcher
I prefer to use just T-SQL to do this. To each his/her own, I guess.
ASKER
@Icohan --- Thank you. I took the command text from the second article and created a PowerShell script. I am able to run it as a scheduled task.
@Scott Pletcher --- Do you have a link where I can find how?
@Scott Pletcher --- Do you have a link where I can find how?
No, I don't have a link.
ASKER
Thank you.
SQL
SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.
61K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
