By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,379 Members | 1,435 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,379 IT Pros & Developers. It's quick & easy.

auto run

100+
P: 115
hi every one

i am developing one new site.

am using sql data base

on year end one table errase and another table update without any program

how can i develop (trigger is possible or jobs)?

pls guide me

Thanks
Yogarajan.G
Mar 20 '08 #1
Share this Question
Share on Google+
3 Replies


ck9663
Expert 2.5K+
P: 2,878
hi every one

i am developing one new site.

am using sql data base

on year end one table errase and another table update without any program

how can i develop (trigger is possible or jobs)?

pls guide me

Thanks
Yogarajan.G

Jobs.

Simulate the program and test it. Once it's done, create a job to run on specific time. If it successfully ran, set it up on specific day (say, tomorrow). If it's successful, set it up on the end of the year. Make sure to check on it on Dec 31.

--CK
Mar 20 '08 #2

100+
P: 115
hi

Thanks For ur reply

can you explain how can i create job in sql

pls guide me

Thanks
Yogarajan.G

Jobs.

Simulate the program and test it. Once it's done, create a job to run on specific time. If it successfully ran, set it up on specific day (say, tomorrow). If it's successful, set it up on the end of the year. Make sure to check on it on Dec 31.

--CK
Mar 25 '08 #3

ck9663
Expert 2.5K+
P: 2,878
Read more here

-- CK
Mar 25 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.