Please help me with job scheduling in SQL Server 2005...
-
Hi all, i have a problem with job scheduling... I have a ssis package (2 actually)... i need this package to loop over and over again. (this package monitors a folder on a server and waits for a specifiec file type before reading the values in that file into the database and formatting the data and ultimately creates a new file with the same name, replacing the old file). Currently i have 2 packages doing this one job... each package ends with a "Execute Package" task. So, Package A would execute Package B at the end and then Package B would execute Package A at the end. (this puts my Job in an infanite loop, which is what i wanted...) BUT now i noticed that each time the package executes the next package, the "Running Packages" (as seen when you log onto the "Integration Services" on the server in SQL Server 2005) gets one extra package... (i presume this takes up memory). So this can't be good in the long run. So what i need help with is the following... 1. I need to put both packages into one package. (i know how to do this.) 2. I need to schedule the package in a job to execute every time the job ends successfully. I need help with the number 2 please... i dont know how to schedule a job to execute as soon as it successfully ended??? Thank you in advance. (any suggestions will be greatly appreciated.)
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
-
Hi all, i have a problem with job scheduling... I have a ssis package (2 actually)... i need this package to loop over and over again. (this package monitors a folder on a server and waits for a specifiec file type before reading the values in that file into the database and formatting the data and ultimately creates a new file with the same name, replacing the old file). Currently i have 2 packages doing this one job... each package ends with a "Execute Package" task. So, Package A would execute Package B at the end and then Package B would execute Package A at the end. (this puts my Job in an infanite loop, which is what i wanted...) BUT now i noticed that each time the package executes the next package, the "Running Packages" (as seen when you log onto the "Integration Services" on the server in SQL Server 2005) gets one extra package... (i presume this takes up memory). So this can't be good in the long run. So what i need help with is the following... 1. I need to put both packages into one package. (i know how to do this.) 2. I need to schedule the package in a job to execute every time the job ends successfully. I need help with the number 2 please... i dont know how to schedule a job to execute as soon as it successfully ended??? Thank you in advance. (any suggestions will be greatly appreciated.)
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
Is this a question about VB or SQL Server 2005?
Steve Jowett ------------------------- Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'
-
Is this a question about VB or SQL Server 2005?
Steve Jowett ------------------------- Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'
So sorry, i thought i clicked on the sql link... my appologies...
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison