Hi iam with a new company now they are using SSIS Packages and these packages are in SQL jobs. with steps. can i create a job that will controll all the jobs? they want me to create a table where all the jobs,stored proceedures and the schedules of jobs are stored and the job that i will create will fetch from the table what job is to be executed in sequence. Please help me to have an idea how iam gonna do this.
Thank you very much!