i would like to run a sql query and other actions automatically and on a daily basis. I need to check the sql database to see if any credit cards are expiring, for example. If so, I need to send an email to that user's email address. I think I can write the code to query the database, but I need to know how to schedule this to run automatically on a daily basis. I do not want to do this manually. I am using VB and visual web developer 2010 express.
The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed.
Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…