Friday, March 30, 2012

Scheduling SQL Agent job

Hello Everyone,

I wanted to schedule my SQL Agent Job with SSIS package loading data into Oracle Destination can it be possible, if not. What do i do to schedule my SSIS package?

Thank you

Yes, it is possible. See the following threads / technet articles on setting up a job / credentials / proxy etc.

http://support.microsoft.com/kb/912911

http://support.microsoft.com/?kbid=918760

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1322146&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1955723&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=703968&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2068280&SiteID=1

No comments:

Post a Comment