Check Execution status when manually running Snapshot agents

I am working on a script to run in Query Analyzer to run all of my SnapShot
agents manually rather than wait for the schedule to do it. I am using
sp_start_job to run each agent such as:
exec msdb.dbo.sp_start_job @.Job_Name='SQLSERVER-SomeSnapshotAgent-167'
waitfor delay '00:30:00' --some fixed time interval to try and have jobs not
run into each other
exec msdb.dbo.sp_start_job @.Job_Name='SQLSERVER-AnotherSnapshotAgent-154'
If I put all of my Snapshot agent jobs in a script to run back to back, how
can I check for execution status so the next job does not run into the
previous agent already running?
Thanks,
Steve
Steve,
you can use the following rputine (modified slightly) to determine the job's
current status.
http://www.replicationanswers.com/Downloads/KillRunningJobs.txt
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||How do I obtain the Guid Job_id for the job name(s) that I am wanting to run?
Thank You
Steve
"Paul Ibison" wrote:

> Steve,
> you can use the following rputine (modified slightly) to determine the job's
> current status.
> http://www.replicationanswers.com/Downloads/KillRunningJobs.txt
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>
>
|||Steve,
it'll be something like this - just replace the name with the name of the
snapshot agent:
select job_id FROM sysjobs
where name = 'UK-3XSW02J\PAULS2000INST-Pub1-2'
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

chart control

I would like to set some of the properties in the chart control at run time
from the database. Is there a way to set the properties at execution time?Some of the chart properties are expressions (and therefore can be set
dynamically), while other properties are static and have to be defined at
design time.
Which properties do you want to control dynamically?
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bill" <Bill@.discussions.microsoft.com> wrote in message
news:6A3A681A-F516-48B7-BEF6-7F77F1C332EC@.microsoft.com...
>I would like to set some of the properties in the chart control at run time
> from the database. Is there a way to set the properties at execution
> time?|||I would like to set the Title and the type of chart.
"Robert Bruckner [MSFT]" wrote:
> Some of the chart properties are expressions (and therefore can be set
> dynamically), while other properties are static and have to be defined at
> design time.
> Which properties do you want to control dynamically?
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Bill" <Bill@.discussions.microsoft.com> wrote in message
> news:6A3A681A-F516-48B7-BEF6-7F77F1C332EC@.microsoft.com...
> >I would like to set some of the properties in the chart control at run time
> > from the database. Is there a way to set the properties at execution
> > time?
>
>|||The chart title can be an expression (although the dialog does not have an
explicit expression button).
The chart type has to be determined at design time.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bill" <Bill@.discussions.microsoft.com> wrote in message
news:D79FC3FF-C13F-4001-A242-C19C440436F3@.microsoft.com...
>I would like to set the Title and the type of chart.
> "Robert Bruckner [MSFT]" wrote:
>> Some of the chart properties are expressions (and therefore can be set
>> dynamically), while other properties are static and have to be defined at
>> design time.
>> Which properties do you want to control dynamically?
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Bill" <Bill@.discussions.microsoft.com> wrote in message
>> news:6A3A681A-F516-48B7-BEF6-7F77F1C332EC@.microsoft.com...
>> >I would like to set some of the properties in the chart control at run
>> >time
>> > from the database. Is there a way to set the properties at execution
>> > time?
>>|||> Regarding: The chart type has to be determined at design time.
BTW: You could have multiple charts defined in your report with different
chart types and dynamically hide all of them based on a report parameter
value (i.e. the select chart type) except for the one you want show. You
would set the Visibility.Hidden property on the charts based on the
parameter values.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:%23DkiTFk3FHA.700@.TK2MSFTNGP15.phx.gbl...
> The chart title can be an expression (although the dialog does not have an
> explicit expression button).
> The chart type has to be determined at design time.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Bill" <Bill@.discussions.microsoft.com> wrote in message
> news:D79FC3FF-C13F-4001-A242-C19C440436F3@.microsoft.com...
>>I would like to set the Title and the type of chart.
>> "Robert Bruckner [MSFT]" wrote:
>> Some of the chart properties are expressions (and therefore can be set
>> dynamically), while other properties are static and have to be defined
>> at
>> design time.
>> Which properties do you want to control dynamically?
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Bill" <Bill@.discussions.microsoft.com> wrote in message
>> news:6A3A681A-F516-48B7-BEF6-7F77F1C332EC@.microsoft.com...
>> >I would like to set some of the properties in the chart control at run
>> >time
>> > from the database. Is there a way to set the properties at execution
>> > time?
>>
>