Hi all,
I am trying to set up a schedule for a data warehouse refresh and I need to be able to code some logic that can determine if the job is already active.
pseudocode:
--Begin job
If (data is ready){
If (job is not running){
Run Job "Refresh Warehouse"
}
}
Else{
Exit
}
I am going to set this code to execute every 15 minutes, but I haven't been able to figure out the "If (job is not running)" part yet.
Any ideas?
John
I am trying to set up a schedule for a data warehouse refresh and I need to be able to code some logic that can determine if the job is already active.
pseudocode:
--Begin job
If (data is ready){
If (job is not running){
Run Job "Refresh Warehouse"
}
}
Else{
Exit
}
I am going to set this code to execute every 15 minutes, but I haven't been able to figure out the "If (job is not running)" part yet.
Any ideas?
John