You should also have someone else review your slides and check for grammatical errors such as:

6. Decide the placement of Demos - ie., how many demos and which one's come...

Try this

ROUND(AVG(CAST(Atraso AS FLOAT)), 0) AS avgAtraso

Kemp

Aaron, if you're still looking you may want to apply to this, Senior Automation Analyst. A large portion of the duties are as a junior dba.

If you're still looking, you can apply for this position, Senior Automation Analyst.

You could create a table, and update it with the status of job 1 by adding an additional step at the end of job 1 that executes on failure of...

Here are some options:

SELECT CONVERT(varchar, getdate(), 113)

SELECT CONVERT(varchar, getdate(), 114)

SELECT CONVERT(varchar, getdate(), 120)

SELECT CONVERT(varchar, getdate(), 121)

------------------------------

01 Sep 2006 15:23:23:927

(1 row(s) affected)

------------------------------

15:23:23:927

(1 row(s) affected)

------------------------------

2006-09-01 15:23:23

(1 row(s)...

Create a view of InControl.dbo.IMP_CUST_tbl_Information within the database InControl. Grant SELECT to the Roles. Have your stored procedure in InControl_QC select from the view.

Look up DTSRun in BOL for the command syntax.

Does ColdFusionUser have execute rights on xp_cmdshell?

You don't want to give the client application access to master. It would be better to have a user table in your application and set a flag for that user...

I have quite a few jobs that import fixed field, flat file text data from legacy mainframe systems into tables. My top performer loads 9 fields of parcel information that...

Use a text file source in DTS. Select fixed field format and just click the desired starting position for each field. Check the Use fast load option on the Transform...

Use a DateTime String conversion for that field's transformation. In the properties for the transform you can then configure both the input format and the output format for the source and destination.

Kemp

I've had a few instances where I create files in jobs and then try to copy them to another location on the network and the copy fails because another process...

Have you considered putting triggers on the table that stores the table definitions to audit the changes?

Kemp