You have not really described your requirements in any detail.

So far, you need a GUI for users to run some reports. The first place I would direct you is...

You really need to read this article:

http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D

Real stab in the dark here, but is xyz.exe trying to display a dialog or form of some sort?

Did you forget to add the variable to the ReadWrite Variables property on the component?

Using MS Access as the front-end application will probably greatly speed up your development process for initial deployment. You get a bunch of great tools for the UI development...

SSMS = SQL Server Management Studio

This is the set of tools for managing SQL Servers. It is not a scheduling system.

With the base tools from SQL Server, you have...

Why do you want o use a cursor?

Wouldn't something like this work?

[font="Courier New"]BEGIN TRAN

SELECT

*

FROM

MyTable

WHERE

Exported = 0

FOR XML RAW

UPDATE

MyTable

SET

Exported = 1

WHERE

Exported = 0

COMMIT TRAN[/font]

SQL 2008 is the last version the old syntax will still be available.

http://msdn.microsoft.com/en-us/library/ms143729(SQL.100).aspx

Search for "Tally Table" on this site and you will find some articles by Jeff about how to do this. He's a pretty smart guy and his articles are...

You can still do the same thing, a query with a TOP clause can be used as a view in SQL 2005.

Even in SQL 2000, this was not a good...

No, the client tools handle the GO batch separator, so the individual batches are sent to the server. There is no way to do what you are suggesting, but...

Why don't you have three fields?

It's interesting that you are getting an index scan on the Geni_SAPHR table. Does it have an index on the CostCtr field?

I would not have expected the query to...

You can use *= and =* for outer joins when putting joins in the WHERE clause. This is the old ANSI standard for join syntax. Using the JOIN...

Create another job that executes msdb..sp_help_job and emails you the results.

The execution status of the jobs indicates if they are running.