sql jobs - ssis packages
Posted on 2011-09-23
Hello guys just a couple of questions.
1:- Apart from ssis being more powerful and having lots of extra features what’s the main difference between a ssis package and a sql server agent job.
The reason I am asking is because I was going to create a ssis package to run a sp, but then I realised I could just create a job.
2:- I know jobs are located under SQL Server Agent Jobs, but where are they actually stored on sql.
3:- ssis packages, if I create a ssis package how do I schedule the package.