Sql Server - Jobs

[nedu]

Hi,

Please let me know, is it possible for me to schedule the job based on the table data(date field in the table).


Regards,
Nedu. M

[iburyak]

You can schedule a job and check data in the table inside. If data doesn't satisfy some condition, then exit job with out execution.

Good Luck.

[Jogos]

1
As in previous reply you can shedule a job on a frequent basis and check the time and quit when not met, you wil have to mark something when job has run.

2
You can use the msdb.dbo.sp_add _job procedure to shedule the job on the time you want, for example the time which comes from somewhere in your database.
Be aware that once created the change of your data will not have implication on the sheduled job.